I'm new in laravel 5 how can i convert this query to laravel ORM
select `users`.`id`, `users`.`username`, count(`ord`.`id`) As total
FROM `users`
LEFT JOIN `orders` AS `ord` ON `ord`.`empolyee_id` = `users`.`id`
AND DATE(`ord`.`created_at`) = $date
GROUP BY `users`.`id`
I tried this solution but it didn't work correctly
$orders = Order::rightjoin('users',function($join) use($date){
$join->on('users.id', '=','orders.empolyee_id');
$join->on("DATE(created_at)", '=', $date);
})
->select(DB::raw('count(orders.id) as total, users.username'))
->groupBy('users.id')->get()