Confusing of Getting Subquery (HELP)

[indrazm]

Hello.

I have this query.

SELECT
    p.id AS postId,
    p.content AS postContent,
    p.img AS postImg,
    p.createdAt AS postCreatedAt,
    (SELECT COUNT(*) FROM replies r WHERE r.postId = p.id) AS replyCount,
    (SELECT COUNT(*) FROM likes l WHERE l.postId = p.id) AS likeCount
FROM
    posts p;

How can i convert to drizzle query ?