lanipov795

SELECT id as refer, count(ref_id) as refers_count
FROM users
WHERE
ref_id is not null
GROUP BY ref_id
ORDER BY 2 DESC LIMIT 5;

message.from_user.id
message.from_user.first_name
message.from_user.last_name
message.from_user.username