查询生成器并使用laravel查找一个表中不存在的记录

Question

I am using Laravel 5 and its Query Builder to retrieve data from database. I want to take following output.

I want to take this question thinks using Query Builder

Now I try this code, but not successfully:

$all_members = CommiteeMember::join('members', 'commiteeMembers.memberId', '<>', 'members.id')
->where('commiteeId', $commitee->id)->get();

Answer 1

I don't know what are you trying to achieve.

But from your title looks like what you need is left join.

 $all_members = CommiteeMember::leftJoin('members', 'commiteeMembers.memberId', '<>', 'members.id')
->where('commiteeId', $commitee->id)->get();