Drizzle: Many to Many on same Table (user has users followers, users followees )

[orenmizr]

summarized code:

export const **users** = pgTable('users', {
  id: serial('id').primaryKey(),
  followers: integer('followers'),
  following: integer('following'),
});

export const usersRelations = relations(users, ({ many }) => ({

  **following**: many(users, {
relationName: 'following', <- was requested by orm errors but does not work
  }),
  **followers**: many(users,{
    relationName: 'followers', <- also does not work
  }),
}));