Longer exposure is the trick, and framing the shot away from other light sources. The camera doesn’t really matter, as long as you can manually adjust things (try pro mode on a phone), and have it mounted on something that won’t shake during the exposure.

With that, aurora photos very often aren’t as they would appear to the eye because of that long exposure. They can still get reasonably bright though.