How do i create a query in Laravel 5.2 query builder, group by

I have the following sql query.

$s2 = "SELECT id FROM transaksi WHERE tarikh='$tar' AND idPekerja IN (SELECT idPekerja FROM pekerja WHERE '$tar' BETWEEN mula AND tamat $samb) GROUP BY idPekerja,tarikh"; $r2 = mysql_query($s2) or die(mysql_error()); $jumHadir = mysql_num_rows($r2); return $jumHadir;

via Chebli Mohamed