title: Get Laravel Eloquent Collection from raw query
body: <p>I'm using Laravel 5 and I have a table of users, and two tables 'clients' and 'employes' which contain relations between users.</p>
  
  <p>I would like to get all the clients and employees of the logged in user.</p>
  
  <p>I have a raw query which works fine for that: </p>
  
  <pre><code>select users.* from clients, users
  where clients.id_marchand = 8 and users.id = clients.id_client 
  union 
  select users.* from employes, users 
  where employes.id_marchand = 8 and users.id = employes.id_employe 
  order by `seen` asc, `created_at` desc limit 25 offset 0
  </code></pre>
  
  <p>Raw queries are returning an array, but I need to get an Eloquent Collection like :</p>
  
  <pre><code>return $this-&gt;model
  -&gt;where(...)
  -&gt;oldest('seen')
  -&gt;latest()
  -&gt;paginate($n);
  </code></pre>
  
  <p>I've tried a lot of different possibilities, but none of them is working...</p>
  
  <p>Isn't there a way to do that with subqueries, or something else ?</p>