title: Laravel eloquent whereNotExists with join
body: <p>Is there a way to rewrite this pseudo query using Eloquent?</p>
  <pre><code>select * from a1, b1
  where a1.id=b1.a_id
  and not exists (select 1 from a1, b1, c1 where a1.id=b1.a_id and b1.id=c1.b_id)
  </code></pre>
  <p>I've tried the following approach, but couldn't figure out how to pass multiple tables in closure</p>
  <pre><code>A1_Model::where('a1.is_active', 1)
  -&gt;join('b1', 'b1.a_id', '=', 'a1.id')
  -&gt;whereNotExists(function ($query) {
              $query-&gt;select(\DB::raw(1))
                  -&gt;from('a1') // how can I pass two tables here? Array doesn't work
                  -&gt;whereRaw('');
          })
  </code></pre>