Dream? Return?

i remember singing a beautiful lullaby to my children in the early 1990s that I had heard on a lullaby cd. it spoke about a child whose dream at night is that mother is leaving, but the mother reassures him/her that she will be right here when they wake up.

It would be so hopeful if someone else remembers this lovely song. i believe it was song by a woman. Let me know if you have the lyrics.

Thanks so much.