Drizzle get relation count

drizzle.ts

// final query
public async getInfluencersWithReferrals() {
  return db
    .select({ user: userSchema, referralsCount: sql<number>`count(${referralSchema.id})` })
    .from(userSchema)
    .innerJoin(referralSchema, eq(userSchema.id, referralSchema.userId))
    .groupBy(userSchema.id);
}

// reverse query
public async groupedReferralsWithUser() {
  return db
    .select({
      userId: referralSchema.userId,
      count: sql<number>`count(${referralSchema.userId})`,
      user: userSchema,
    })
    .from(referralSchema)
    .leftJoin(userSchema, eq(referralSchema.userId, userSchema.id))
    .groupBy(referralSchema.userId)
    .having(({ count }) => gt(count, 1));
}