Laravel Eloquent - 表加入

Question

I have one problem where I need help. I'm doing one project in learning purposes.

I have 2 tables, the first one is

USERS which contain id (PK, AI), username, email, password and so on...

Another table called

FRIENDS

contain user_a (FK to users.id), user_b (FK to users.id), status (0 - pending, 1 - confirmed)...

Lets say the current logged user have id 1.

I need to join this 2 tables and get complete friend list for currently logged user, so query trough table friends where user_a or user_b = currently logged user id, and get all data (from table users) for his friend... So lets say this:

user_a = 1, user_b = 2 userb_a = 3, user_b = 1

I need to get info for users 2, 3.

I hope so you understand what I need.

Btw I know how to do this without using Eloquent, but I need to use Eloquent.

Thanks a lot!

Answer 1

This is many to many relationship, so you need belongsToMany.

// basic setup
public function friends()
{
    return $this->belongsToMany('User', 'friends', 'user_a', 'user_b')
      ->withPivot('confirmed');
}

However that's not all, since you want it to be bidirectional. This means you need to setup 2 relationships - here you can find exact solution for this:

Friendship system with Laravel : Many to Many relationship