one-to-many self reference

 typescript
export const contacts = mysqlTable("contacts", {
  id: int("id").primaryKey(),
  parentId: int("parent_id"),
  ...
}, (table) => {
  return {
    parentReference: foreignKey({
      columns: [table.parentId],
      foreignColumns: [table.id],
      name: "fk_contacts_parent_id"
    }),
  };
})

 typescript
export const contacts = mysqlTable("contacts", {
  id: int("id").primaryKey(),
  parentId: int("parent_id"),
  ...
}, (table) => {
  return {
    parentReference: foreignKey({
      columns: [table.parentId],
      foreignColumns: [table.id],
      name: "fk_contacts_parent_id"
    }),
  };
})

  parentId: int('parent_id').references(() => contacts.id),

  parentId: int('parent_id').references(() => contacts.id),

'contacts' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.ts(7022)

'contacts' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.ts(7022)

export const contactsRelations = relations(contacts, ({ many, one }) => ({
  contactCustomFields: many(contactCustomFields),
  parent: one(contacts, {
    fields: [contacts.parentId],
    references: [contacts.id],
  }),
  familyMembers: many(contacts),
})),

export const contactsRelations = relations(contacts, ({ many, one }) => ({
  contactCustomFields: many(contactCustomFields),
  parent: one(contacts, {
    fields: [contacts.parentId],
    references: [contacts.id],
  }),
  familyMembers: many(contacts),
})),

const result = await db.query.contacts.findMany({
    with: {
      parent: true,
      familyMembers: true,
    },
    limit: 1
  })

const result = await db.query.contacts.findMany({
    with: {
      parent: true,
      familyMembers: true,
    },
    limit: 1
  })