There isn't a real comparison with low light mode on phones vs what the best SLRs can do at high ISO at night.
Phones are now using a combination of photo stacking and HDR in order to achieve pretty ridiculous low-light results.
You could certainly sit there with an SLR and bracket half a dozen shots and then stack/HDR them in post, but that is a lot more work and can't be uploaded to facebook/instagram seconds later ;)