query with one to many (postgres + foreign keys)

export const accounts = pgTable("accounts", {
  id: serial("id").primaryKey(),
  address: text("address").notNull(),
  createdAt: timestamp("created_at").defaultNow().notNull(),
  updatedAt: timestamp("updated_at").defaultNow(),
  points: integer("points").default(0).notNull(),
});

export const nfts = pgTable("nfts", {
    id: serial("id").primaryKey(),
    contractAddress: text("contract_address").notNull(),
    tokenId: integer("token_id").notNull(),
    accountId: integer("account_id").references(() => accounts.id)
});

db.query.accounts.findFirst({
  where: eq(accounts.address, "0xDEAD...BEEF"),
  with: { nfts: true },
});