prisma relation

gistfile1.txt

model Users {
  id                  String            @id @default(auto()) @map("_id") @db.ObjectId
  name                String
  applicant           Applicant?
  reviewed_applicant  Applicant[]       @relation("ParentChild")
}

model Applicant {
  id             String  @id @default(auto()) @map("_id") @db.ObjectId
  status         Boolean
  owner          Users   @relation(fields: [owner_id], references: [id])
  owner_id       String  @unique @db.ObjectId
  reviewed_by    Users   @relation("ParentChild", fields: [reviewed_by_id], references: [id], onDelete: Cascade, onUpdate: NoAction)
  reviewed_by_id String  @unique @db.ObjectId
}

const users = await prisma.users.findMany({
    include: {
      applicant: true,
      reviewed_applicant: true
    },
  });
  console.log("users", users);

output:
users [
  {
    id: '65ba62500bfd1f23de36476d',
    name: 'Intern Dela Cruz',
    applicant: {
      id: '65c3a8b83460a35367ff3bfd',
      status: true,
      owner_id: '65ba62500bfd1f23de36476d',
      reviewed_by_id: '65c2d244816901d1ddbe8779'
    },
    reviewed_applicant: []
  },
  {
    id: '65c2d244816901d1ddbe8779',
    name: 'Siñior Jake Simpas',
    applicant: null,
    reviewed_applicant: [ {
        id: '65ba62500bfd1f23de36476d',
        name: 'Juan Dela Cruz',
    } ]
  }
]