US President Donald Trump has bowed to public pressure and signed an executive order promising to "keep families together" in migrant detentions.