I am trying to locate this story I heard awhile ago, but I have forgotten where I heard it from. I believe it is Greek/Roman myth. This is what I remembered from the story. It is about a woman who has two sons (I believe it was two sons, maybe one). Her sons are incredibly obedient and overall great human beings. The woman prayed to the Gods that her sons be remembered as great humans beings by everyone forever. So the gods killed her sons because that was the only way they can be immortalized. I hope this information is helpful.
I have finally remembered the myth you are referring to: it is the Greek myth of the brothers Cleobis and Biton(also spelled Bito).
They were the sons of Cydippe, the priestess of the goddess Hera, wife of Zeus and queen of the gods.
When Cydippe wished to travel to the temple of Argos during an Argival festival honouring Hera and asked her sons to yoke two young white cows to a wagon, Cleobis and Biton, distinguished for his filial affection and for their athletic strength, did not find the cows, and then took up the yoke of the ceremonial wagon and conveyed her there themselves, as a token of their love.
Then Cydippe prayed to the gods that her sons be remembered as great humans beings by everyone forever, and begged to grant them, as a reward for their piety, whatever was best for mortal men.
So, the gods got Cleobis and Biton, who were sleeping that night in the temple of Hera, to never awake because that was the only way they can be immortalized.
The Argives made and dedicated at Delphi statues of them as being the best of men.
You can read this story in Herodotus, The Histories, book 1, chapter 31, section 1-5, and Cicero, Tusculan Disputations, Book 1, section 113.
[See the links below].
Herodotus, The Histories, book 1, chapter 31, section 1-5
CICERO, Tusculanae Disputationes, Book 1, section 113