SELECT C.id, C.name, COUNT(P.cat_id) AS cnt
FROM `categories` AS C
LEFT JOIN `post` AS P ON C.id=P.cat_id
GROUP BY C.name