Вывести совпадения Laravel + MySql

$users = DB::table('likes')
            ->leftJoin('users','users.id','=','likes.like_user')
            ->leftJoin('user_attributes','user_attributes.user_id','=','likes.like_user')
            ->select('user_attributes.fullname','user_attributes.avatar','user_attributes.country','user_attributes.city','user_attributes.age',
                'users.name','users.id','likes.created_at')
            ->where('likes.like_user','=', 'likes.user_id')
            ->where('likes.user_id','=', Auth::user()->id)
            ->paginate(15);

SELECT t1.user_id 
FROM likes t1
JOIN likes t2 ON t1.user_id = t2.like_user 
             AND t2.user_id = 1
             AND t1.like_user = 1

и, если я верно понимаю синтаксис, то

$users = DB::table(DB:raw('likes t1'))
       ->join(DB:raw('likes t2'), 't1.user_id', '=', 't2.like_user ')
       ->where('t2.user_id', '=', '1')
       ->where(' t1.like_user', '=', '1')

SELECT
  l1.*
FROM
  likes l1
  JOIN likes l2 ON (l1.like_user = l2.user_id)
WHERE
  l1.user_id = 1 OR
  l1.like_user = 1

рабочий код

$users = DB::table('likes AS t1')
            ->join('likes AS t2', 't1.user_id', '=', 't2.like_user')
            ->leftJoin('users','users.id','=','t1.user_id')
            ->leftJoin('user_attributes','user_attributes.user_id','=','t1.user_id')
            ->select('user_attributes.fullname','user_attributes.avatar','user_attributes.country','user_attributes.city','user_attributes.age',
                'users.name','users.id','t1.created_at')
            ->where('t2.user_id', '=', Auth::user()->id)
            ->where('t1.like_user', '=', Auth::user()->id)->distinct('t1.user_id')->get();