Why do good people not necessarily get good results, but bad people do? Can this be explained by the Book of Changes? Is it better to be a good person or a bad person?

Take the Book of Changes as an example, "Happiness depends on misfortune, and misfortune depends on happiness", and take Yin and Yang as an example, "Yang holds on Yin and Yin holds on Yang", so good people sometimes do bad things and bad people sometimes do good things. Good and evil will eventually be rewarded, not without it, but not yet. The development of everything is constantly changing. For example, doing bad things when people are lucky does not affect the present situation, but doing bad things lays the groundwork for bad luck in the future. "There must be Qing Yu in a well-built house, but there will be more disasters in a poorly built house." Good and evil will eventually be rewarded, and cause and effect will lead to the third (past life and afterlife), and everyone's behavior will determine their own destiny.