How can I convert this sql query to Laravel

SELECT a.*, c.brand_name FROM coupon_user_mapping a, offers b , brand c WHERE a.user_id = "SSG0043" and a.offer_id = b.id and b.brand_id = c.brand_id

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