Get Laravel Eloquent Collection from raw query
<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>