It's much more common in Latin America than Spain. Literally it's "little mama" or Mummy. But if somebody else other than your children calls you mamacita it means that you're hot.
When I call my Mexican wife mamacita I'm not actually quite sure which meaning. I hope she takes it that she's hot.