Hello @maranda5,
Welcome to the forum
I’m so sorry to hear about your friend and I think you are very kind for looking for ways to help them. I agree with what others have shared - unless the coma was the direct result of a curse (in which case you could attempt to break the curse), for a non-magickal coma, healing spells would be my recommendation as well.
Others have shared some great healing spell suggestions, and I second Georgia’s suggestion of adding them to the Energy Exchange Circle - let us know if you’d like an entry to be added
Another spell to add to the pile is the Lighthouse Spell. It can send aid and healing energy to someone in need, no matter where they may be:
Wishing you and your friend only the best. Blessed be