Реляционный запрос

SELECT b.id, b.views, COUNT(c.id) as comm_count
FROM blog b LEFT JOIN blog_comments c ON (c.blog_id = b.id)
GROUP BY b.id