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!