SELECT c.name,count(u.clinet_id) count
FROM user_post u
LEFT JOIN clinet c ON u.clinet_id=c.id
GROUP BY c.name
ORDER BY count DESC