CODE EXAMPLE FOR PHP

join table laravel count

DB::table('users')
        ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
        ->get();