To create Many-to-many relationship in Prisma, you do it like so. Prisma, in the background, will create a table for you with a relation.
model Category {
id String @id @default(cuid())
title String
products Product[]
}
model Produt {
id String @id @default(cuid())
name String
categories Category[]
}