title: Eloquent 2 left join query
body: <p>I would like to execute the following query using Laravel's eloquent query builder:</p>
  
  <pre><code>SELECT a.*, b.day, c.sex FROM hours as a
  left join reserves as b
  on a.id = b.hour_id and b.day = '2015-12-12'
  left join doctors as c
  on a.doctor_id = c.id
  where a.doctor_id = 1;
  </code></pre>
  
  <p>I have tried the following:</p>
  
  <pre><code>Hour::leftJoin('reserves', function($join) {
      $join-&gt;on('hours.id' , '=' , 'reserves.hour_id')
          -&gt;where('reserves.day' , '=' , '2015-12-12');
  })
  -&gt;leftJoin('doctors', function($join) {
      $join-&gt;on('hours.doctor_id', '=', 'doctors.id'); 
  })
  -&gt;where('hours.doctor_id', '=', $doctorId)
  -&gt;get();
  </code></pre>
  
  <p>Unfortunately, I am not getting the same results.</p>