More than one relationship with the same collection?

I am implementing followers and following system for my rn app, but unable to have relationship with same collection 2 times Eg.

1. follower_id
2. following_id

Both attributes should have relationship with users collection, How is it possible??

I have no problem creating more than one relationship in the same collection, are getting some error? can you share the attributes of the 3 collections?

I also don't have problem creating relationship more than one with different collections

I want multiple relationship with same collection

Is the Relationship one-to-many? Many-to-one? Etc

Many to many

Let me explain: I have two attributes

1. follower_id
2. following_id

I want to get both follower and following user data when I fetch document from followers collection, that's why I need relationship in both attributes with same collection

Yeah. I don’t think that’s possible at the moment.

When will appwrite support complex queries like Join, subqueries... Etc