title: Using Laravel's WhereIn to search multiple tables
body: <p>I have 3 SQL tables.</p>
  <ol>
  <li>clients</li>
  <li>events</li>
  <li>client_events</li>
  </ol>
  <p>Because a client can have multiple events, I made the third table to show those relationships. I am using the following code to retrieve all of the clients that have the have a record matching this event, but it is only returning 1 record when there are multiple.</p>
  <pre><code>$eventHosts = DB::table('clients')-&gt;whereIn('id', function($query) {
      $query-&gt;select('client_id')-&gt;from('client_events')-&gt;where('event_id', '=', explode('/', $_SERVER['REQUEST_URI'])[2]);
  })-&gt;get();
  </code></pre>
  <p>What am I overlooking?</p>