select u.*,
(select count(*) from subscribes s where s.to_user_id=u.user_id) as SUBSCRIBESCOUNT
from users u
order by u.rating desc, SUBSCRIBESCOUNT desc, u.place asc
SELECT u.*, COUNT(s.*) cnt
FROM users u
LEFT JOIN subscribes s ON u.user_id = s.to_user_id
GROUP BY u.user_id
ORDER BY u.rating DESC, cnt DESC, u.place ASC
