many-to-may relation
How do i define relation like a post probably has many comments that nested, for example a person can reply to other person's comment,
export const comments = mysqlTable(
'comments',{
id: serial('id').primaryKey(),
postId: int('post_id'),
comment: text('content').notNull(),
authorId: int('author_Id').notNull(),
parentId: int('parent_id'),
likes: int('likes').default(0),
},
);