What To Do When You Have A Relationship Between Two Objects Of The Same Type

Lets say user1 is friends with user2 where user one is a relationship table. How do you connect two users on the same id i.e. user_id?

user_id -> friends with -> user_id

friends table

user_id | user_id | description | created_at | updated_at

We can't have two user_id's so any suggestions how can I do this?

Thanks for your help! :slight_smile:

Hello John,