Subquery in select

select "user"."name", "userAddress"."address", (select count(*) from "userLike" ul where ul."likerId" = "user".id) as "likeCount" from "user" 
left join "userAddress" on "userAddress"."sender_user_id" = "user"."id" 
where "user"."id" < 50

export const user = pgTable('user', {
    id: serial('id').primaryKey(),
    name: text('name'),
});

export const userAddress = pgTable('userAddress', {
    id: serial('id').primaryKey(),
    userId: integer('sender_user_id').references(() => user.id),
    address: text('address'),
});

export const userLike = pgTable('userLike', {
    id: serial('id').primaryKey(),
    likedId: integer('likerId').references(() => user.id),
    userId: integer('userId').references(() => user.id),
});

const result2 = await db.select({
    kokos: user.name,
    address: userAddress.address,
    likeCount: //dunno
})
.from(user)
.leftJoin(userAddress, eq(userAddress.userId, user.id))
.where(lt(user.id, 42));