How to do this subquery in laravel

How can I make this query in Laravel:

select *,
(select status from user_intrest where `to` = 74 and `from` = 59) user_status 
from siteuser

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