Unable to use one-to-many relational query on same table

[DireWolf707]

Schema :

export const tweetT = pgTable(
  "Tweet",
  {
    id: uuid("id").defaultRandom().primaryKey(),
    content: text("content").notNull(),
    mediaURL: varchar("media_url", { length: 256 }),
    mediaType: varchar("media_type", { length: 12, enum: ["img", "vid"] }),
    userId: uuid("user_id")
      .notNull()
      .references(() => userT.id),
    parentTweetId: uuid("parent_tweet_id"),
    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
  },
  (tweetT) => ({
    parentTweetRef: foreignKey({
      columns: [tweetT.parentTweetId],
      foreignColumns: [tweetT.id],
    }),
    userIdx: index("user_idx").on(tweetT.userId),
    parentTweetIdx: index("parent_tweet_idx").on(tweetT.parentTweetId),
  })
)

Relations :

export const tweetTRelations = relations(tweetT, ({ one, many }) => ({
  parentTweet: one(tweetT, {
    fields: [tweetT.parentTweetId],
    references: [tweetT.id],
    relationName: "parentTweet",
  }),
  comments: many(tweetT, { relationName: "comments" }),
}))

Code :

  const tweet = await db.query.tweetT.findFirst({
    where: eq(tweetT.id, tweetId),
    with: {
      comments: true,
    },
  })

Error :

There is not enough information to infer relation "tweetT.comments"