How to get another linked tables count?

import { eq } from "drizzle-orm";

export default eventHandler(async (event) => {
  const session = await requireUserSession(event);
  const collections = await useDb()
    .select()
    .from(tables.collections)
    .where(eq(tables.collections.userId, session.user.id))
    .all();
  return collections;
});