SELECT
  category,
  COUNT(*) AS `num`
FROM
  posts
GROUP BY
  category