Select and Groupby in Laravel

How can i use this script in laravel controller?

 SELECT MAX(branch_tbl.branch_name) AS Branch_Name, COUNT(staffinfo.branchID) AS Count_Branch
    FROM branch_tbl
    LEFT JOIN staffinfo ON staffinfo.branchID = branch_tbl.branch_id
    GROUP BY branch_tbl.branch_id;

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