Eloquent Relationship with multiple left joins

Hello,

I'm not sure to understand what you need. In your query you ned only one left join but you have multiple conditions.

The Query Builder helps you to write the query and Eloquent helps you writing the relationships between the different models. And your question seems to ask how it is possible to write the query with Eloquent ?

So I have a question : do you need help to write the query with the query builder or to write the relationships in your models ?

Query Builder

$result = Student::join('users', 'users.id', '=', 'students.id')->...->get();

Eloquent

// In the User model

public function student()
{
	return $this->hasOne('App\Models\Student');
}

// In the Student model

public function user()
{
	return $this->belongsTo('App\Models\User');
}