What is the best way to get user likes along with messages?

Question

MySQL

It is necessary to get information about whether the user who views the messages likes it. What is the best way to do this?
At the moment, a request has been written to receive posts and the number of likes.

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

Answer 1

If there is a userid in post_likes, then add another join:
LEFT JOIN `post_likes` AS `plu` ON `plu`.`postId` = `p`.`id` and `plu`.`userId` = `p`. `userid`