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

via Chebli Mohamed