mysql - Select MAX() and respective id -

select max(count),id_university (     select count(*) count, id_university `users`      status = 2 , id_university>0      group id_university )as counts 

currently above query gives me id_university = 1 instead respective value.

how can respective id_university maximum count?

use order by , limit

select count(*) count, id_university users status = 2 , id_university > 0 group id_university order count desc limit 1