DEEPLY NESTED QUERY using { with }

const categories = await db.query.category.findMany({
        with: {
          categories: true
        }
 })

export const category = pgTable("category", {
  id: uuid("id").primaryKey().defaultRandom(),
  slug: varchar("slug", { length: 255 }).notNull(),
  name: varchar("name", { length: 255 }).notNull(),
  parent_id: uuid("parent_id").references((): AnyPgColumn => category.id)
});