title: Query from two tables laravel with multiple conditions
body: <p>I'm trying to write this query in Laravel query</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
      table1.*, table2.* 
  FROM
      table1
  LEFT JOIN
      table2
  ON
      (table1.id = table2.id AND (table2.field =  '' OR table2.field &gt;=  '0'))
  WHERE
      table.id = id
  </code></pre>
  
  <p>I have problem with how to add inner part <code>AND ( ... )</code> to the query? Here is what I have so far</p>
  
  <pre class="lang-php prettyprint-override"><code>$query = Table::select(
      DB::Raw('table1.*, table2.*'))
          -&gt;leftJoin('table2', function($join) {
              $join-&gt;on('table1.id', '=', 'table2.id')
                   -&gt;where('table2.field', '=', '')
                   -&gt;orwhere('table2.field', '=', '50');
  })-&gt;where('table1.id', BaseController::getCurrentUser()-&gt;id)
    -&gt;get();
  </code></pre>
  
  <p>I miss where and how to add <code>AND</code> ...</p>