SELECT `p`.`id`, `p`.`userId`, `p`.`message`, COUNT(`pl`.`postId`) as cnt_likes
FROM `posts` AS `p`
LEFT JOIN `post_likes` AS `pl` ON `pl`.`postId` = `p`.`id`
WHERE `p`.`userId` = :userId
GROUP BY `p`.`id`
ORDER BY `p`.`id` DESC
Find more questions by tags DatabasesMySQLSQLWeb Development