Many to many relations & inferred model

[killjoy2013]

I have user schema;

export const users = pgTable(
  "user",
  {
    id: serial("id").notNull().primaryKey(),
    name: text("name").notNull(),
    email: text("email").notNull(),
    emailVerified: timestamp("emailVerified", { mode: "date" }),
    image: text("image"),
    address: text("address"),
    createdAt: timestamp("createdAt")
      .default(sql`now()`)
      .notNull(),
    updatedAt: timestamp("updatedAt")
      .default(sql`now()`)
      .notNull(),
    updatedBy: integer("updatedBy").references((): AnyPgColumn => users.id, {
      onDelete: "set default",
    }),
  },
  (table) => ({
    emailIdx: uniqueIndex("email_idx").on(table.email),
  })
);

export type User = typeof users.$inferSelect;

export const usersRelation = relations(users, ({ many }) => ({
  userRoles: many(userRoles),
}));

role schema;

export const roles = pgTable("roles", {
  id: serial("id").notNull().primaryKey(),
  name: roleEnum("name").notNull(),
});

export type Role = typeof roles.$inferSelect;

export const rolesRelation = relations(roles, ({ many }) => ({
  userRoles: many(userRoles),
}));

userRole schema;

export const userRoles = pgTable("userRoles", {
  id: serial("id").notNull().primaryKey(),
  userId: integer("userId").references((): AnyPgColumn => users.id, {
    onDelete: "set default",
  }),
  roleId: integer("roleId").references((): AnyPgColumn => roles.id, {
    onDelete: "set default",
  }),
});

export type UserRole = typeof userRoles.$inferSelect;

export const usersToRolesRelations = relations(userRoles, ({ one }) => ({
  role: one(roles, {
    fields: [userRoles.roleId],
    references: [roles.id],
  }),
  user: one(users, {
    fields: [userRoles.userId],
    references: [users.id],
  }),
}));

inferring user like this,
export type User = typeof users.$inferSelect;

the shape or User is

type User = {
    id: number;
    name: string;
    email: string;
    emailVerified: Date | null;
    image: string | null;
    address: string | null;
    createdAt: Date;
    updatedAt: Date;
    updatedBy: number | null;
}

how to add roles array to User like this;

type User = {
    id: number;
    name: string;
    email: string;
    emailVerified: Date | null;
    image: string | null;
    address: string | null;
    createdAt: Date;
    updatedAt: Date;
    updatedBy: number | null;
    roles: Role[]
}

shall I query user like this?

const foundUsers: User = await db.query.users.findMany({
    where: (user) => ilike(users.name, `%${name}%`),
    with: {
      userRoles: {
        with: {
          role: true,
        },
      },
    },
  });