get the most purchases product for current user

I have 3 tables here (order_lists, order_details, products)

Table order_lists contain the following user_id

Table order_details contain the following order_lists_id product_id

Table products contain all the products details.

the three tables are related to each others in models.

I need to select the most purchases items from table order_details based this user_id.

I made very basic Eloquent query which will select 6 products for this user but stuck on how to get the most purchases product

$mostPurchases = OrderList::where( 'user_id', Auth::id() )
                 ->with( [
                   'orderDetails' => function ( $query ) {
                         $query->with( 'productId' );
                    }
                 ] )->take( 6 )->get();

but this didn't work as expected

so I used the DB

DB::table( 'products' )
              ->leftJoin( 'order_details', 'products.id', '=', 'order_details.product_id' )
              ->select( DB::raw( 'count(*) as pro_count, product_id' ) )
              ->leftJoin( 'order_lists', 'order_details.order_lists_id', '=', 'order_lists.id' )
              ->where( 'order_lists.user_id', '=', $usId )
              ->orderBy( 'pro_count', 'DESC' )
              ->groupBy( 'product_id' )
              ->take( 6 )
              ->get();

This working fine but don't get the products details

it just returns the (product_id, and the pro_count)

something like this

        {
            "pro_count": 22,
            "product_id": 733
        },

how can I return the product details with the response.