How to do this in drizzle schema?

I moved from PrismaORM convert this model schema to drizzleSchema (nested self)
How to do that?

model Category {
  id       Int        @id @default(autoincrement())
  name     String
  parentId Int?
  parent   Category?  @relation("ParentChild", fields: [parentId], references: [id])
  children Category[] @relation("ParentChild")
  Product  Product[]
}
Was this page helpful?