What is the meaning of to cry for the moon in idioms?

"To cry" in this sense means "to beg for." If you beg for the moon, you're wanting something way out of your reach and impossible to get.