In my use case, the business logic is to create a secret friend type of app. The logic should allow the user to create a group of friends. The same friend can be in the different groups.
So I'm thinking that this is a many-to-many relationship case.
In one of my solutions, my idea was to have 3 tables:
friends | groups | friend_pair_groups |
---|---|---|
id | id | id |
name | friend_giver_id | name |
phone_number | friend_receiver_id |