It is similar to English terms like "honey", "sweetheart", or "little one", and is used in a very affectionate way.
It's important to note that while "mambi" can sometimes be used for older children or even adults, it's generally reserved for those who are considered young and innocent.