CODE EXAMPLE FOR PHP

left join in laravel

$data = DB::table('post')
  ->leftJoin('category', 'post.category', '=', 'category.id')
  ->leftJoin('users', 'post.author', '=', 'users.id')
  ->orderBy('created_at', 'DESC')
  ->get();