Querying and typing a many to many relationship?

// Drizzle relationships:
export const userRelations = relations(users, ({ many }) => ({
  usersToProfiles: many(userToProfiles),
}));

export const profileRelations = relations(profiles, ({ many }) => ({
  usersToProfiles: many(usersToProfiles),
}));

export const usersToProfilesRelations = relations(
  usersToProfiles,
  ({ one }) => ({
    user: one(users, {
      fields: [usersToProfiles.userId],
      references: [users.id],
    }),
    profiles: one(profiles, {
      fields: [usersToProfiles.profileId],
      references: [profiles.id],
    }),
  }),
);

// Querying all users and their profiles
  const listings = await db.query.users.findMany({
    with: {
      usersToProfiles: {
        with: {
          profiles: true,
        },
      },
    },
  });

export const userSchema = createInsertSchema(users);
export const UserWithProfilesSchema = userSchema.extend() // not sure how to extend here
export type UserWithProfileType = z.infer<typeof UserWithProfileSchema>;