How to do this subquery in laravel [closed]

How can I make this query in Laravel:

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

via Chebli Mohamed