MySQL Query in Laravel Eloquent

Question

How can I do the equivalent in Eloquent (i.e. Model::where(...)->join(...)?:

DB::select('SELECT users.id, users.username
        FROM users, teams, teams AS teams2
        WHERE users.team_id = teams2.id
        AND teams.id = ?
        AND teams2.l BETWEEN teams.l AND teams.r', [$id])

Cong Chen · Accepted Answer · 2017-01-19 01:09:14Z

1

Edited:

$team = Team::find($id);
$users = User::join('teams', 'teams.id', '=', 'users.team_id')
             ->whereBetween('teams.l', [$team->l, $team->r])
             ->get(['users.id', 'users.username']);

edited Jan 19, 2017 at 1:09

answered Jan 18, 2017 at 8:52

Cong Chen

2,43615 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

imperium2335 Over a year ago

Thanks, but unfortunately that doesn't work, it just gives me the members of the team with $id, and not the team with $id and all members of child teams.

imperium2335 Over a year ago

I assume because all teams in 'teams.l BETWEEN teams.l AND teams.r' must have id $id.

imperium2335 Over a year ago

Getting: Argument 2 passed to Illuminate\Database\Query\Builder::whereBetween() must be of the type array, object given

Cong Chen Over a year ago

Updated, call toArray() after values().

Collectives™ on Stack Overflow

MySQL Query in Laravel Eloquent

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related