我有两个表USERS表和LIKES表,我想使用laravel querybuilder编写一个查询,以获取用户喜欢的内容,然后检查该用户是否被喜欢。我尝试了以下操作,但是即使两个用户都喜欢自己,ID仍为null。
$mutual_likes = Like::select(
'u.*','l.id'
)
->join('users as u',function($join) {
$join->on('u.id','likes.like_receive')
->where('likes.like_give',Auth::user()->id);
})
->leftjoin('likes as l','likes.like_give')
->where('likes.like_receive',Auth::user()->id);
})
->groupBy('likes.id')
->paginate(15);