How to create with Laravel query in controller

who can help me? I was selected from sql. This is my sql. How to create with Laravel query in controller.

SELECT sp.name_en, sp.email, sp.phone, post.name AS position_name FROM staff_profiles sp INNER JOIN staff_positions p INNER JOIN positions post WHERE sp.id=p.staff_id and p.position_id=post.id

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