It is about a son who is not raised with his father in his life
In the chorus
Cats in the cradle is a reference to the family
Silver spoon is a reference to his fathers money earned from working
Little Boy Blue is reference to his son
Man in the moon is reference to his father being far away.