hcan
use Illuminate\Database\Query\Builder;
use Illuminate\Database\Query\JoinClause;
$users = User::whereNotIn('id', function (Builder $query) {
$query->from('users')
->select('id')
->distinct()
->join('friends', function (JoinClause $join) {
$join->on('users.id', '=', 'friends.users_1')
->orOn('users.id', '=', 'friends.users_2');
});
})->get();