How to perform a join containing a sub query on an Eloquent Relationship in laravel 5

I am new to laravel. I'm working on this laravel 5 app but got stuck on trying to perform a query like below.

select * from carts inner join users on carts.manager_id = users.id
where cart_num like "e%" OR name like "e%"
having region = (select region from users where id = 3);

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1MZtaJg
via IFTTT