使用Laravel 5 eloquent查询构建器的DISTINCT方法

Question

I'm struggling to get unique results when using the DISTINCT method in laravel. This is my query

//Get users that are part of this sector

        $users = DB::table('users')->distinct()
                            ->join('projects', 'users.id', '=', 'projects.userID')
                            ->where('projects.sectorID', '=', $sector->sectorID)
                            ->get();
        dd($users);

The result shows 3 users with the same ID, when I only want one of them in the results.

How should I change my query?

Answer 1

Try to use group by id

$users = DB::table('users')
     ->join('projects', 'users.id', '=', 'projects.userID')
     ->where('projects.sectorID', '=', $sector->sectorID)
     ->groupBy('users.id')
     ->get();

dd($users);