Forum How to do this Query using laravel?

kenoot

posted 8 years ago

Database

Last updated 2 years ago.

terreporter

replied 8 years ago

Maybe something like this,

// might need some tweaking since I do not have a table to test against.

    $projectID = $this->getID();

    $result = DB::table('users')
                        ->select(DB::raw('count(*) as members'))
                        ->whereIn('rank', function($query) use ($projectID) {
                                $query->select('id')->from('user_ranks')->where('project_id', $projectID);
                            })->get()  ;