translate query ini di laravel

 SELECT
	`absens`.`kelas_id` AS `kelas_id`,
	`absens`.`nisn` AS `nisn`,
	(
		SELECT
			`t2`.`kondisi`
		FROM
			`absens` `t2`
		WHERE
			(
				(`t2`.`date` = '20170807')
				AND (`t2`.`kelas_id` = 21)
				AND (
					`t2`.`nisn` = `absens`.`nisn`
				)
				AND (`t2`.`jam_ke` = 0)
			)
	) AS `Jam 0`,
	(
		SELECT
			`t2`.`kondisi`
		FROM
			`absens` `t2`
		WHERE
			(
				(`t2`.`date` = '20170807')
				AND (`t2`.`kelas_id` = 21)
				AND (
					`t2`.`nisn` = `absens`.`nisn`
				)
				AND (`t2`.`jam_ke` = 3)
			)
	) AS `Jam 1`,
	(
		SELECT
			`t2`.`kondisi`
		FROM
			`absens` `t2`
		WHERE
			(
				(`t2`.`date` = '20170807')
				AND (`t2`.`kelas_id` = 21)
				AND (
					`t2`.`nisn` = `absens`.`nisn`
				)
				AND (`t2`.`jam_ke` = 4)
			)
	) AS `Jam 2`
FROM
	`absens`
WHERE
	(
		(`absens`.`date` = '20170807')
		AND (`absens`.`kelas_id` = 21)
	)
GROUP BY
	`absens`.`nisn`