sherburn has got to be one of the best in the north in my opinion but depends if you think its too far.
I dont buy in to this whole if you want to fly airlines fly from an international airport thing. You can get your licence and go land at manchester ringway if you want. It makes no odds.
Yorkshire has some great flying and all the places mentioned will suit your needs. To learn to fly. Go visit a few.
I think sherburn has it all, sandtoft has fewer aircraft and is quieter but its still a great airfield. Netherthorpe has the most challenging runways but phoenix have a great set up too there. You just need to visit a few and see which clicks with you.