How can I make a query so that it would be possible to display the number of rows in a loop?

Question

Laravel

concocted a request:

$user = DB::table('users')
            ->join('users_group', 'users.id_user_group', '=', 'users_group.id_user_group')
            ->join('posts', 'users.id', '=', 'posts.id_user')
            ->select('users.*', 'users_group.group_name', 'posts.id')
            ->orderby('created_at','asc')
            ->paginate(10);

here the user table is associated with user_group and posts rummaged
through the documentation, did not understand anything, how can I calculate how many posts this or that user has and then display this?

Answer 1

Use "relationships" for this. Personally, I use them. And then break into a stake. posts and display what you need

Answer 2

add subselect with count

Answer 3

$users = DB::table('users')->count();
https://laravel.com/docs/5.4/queries#Aggregates