select * from university where id IN (select university_id from university_major where major_id='51') AND status=1

Major:

Listed by alphabetical order - A to z.