laravel eloquent left join group by

GROUP_CONCAT in laravel Eloquent/Raw

Laravel 6 Eloquent LEFT JOIN Query Example Tutorial

Laravel eloquent join with condition

PHP Laravel Eloquent join with subquery