How to make the top 5 most popular users? There is a database of users and subscriptions. PHP?

Question

PHP

I have a user base (id = this is the user id). And the subscription base (fid = the one who subscribed. uid = the one who was subscribed to). How to make TOP-5 popular users with such data?

Answer 1

Well, based on these data, there is only one TOP. The number of subscriptions for a particular user.

Answer 2

Select count(*) cnt, uid from tbl group by uid order by cnt desc