Illuminate\Pagination\LengthAwarePaginator::$username

Hi,

I have a scorelist. I created a component for this. this is the code of my component:

<?php

namespace App\View\Components;

use App\Models\User;
use Closure;
use Illuminate\Contracts\View\View;
use Illuminate\Support\Facades\DB;
use Illuminate\View\Component;

class Scorelist extends Component
{
    /**
     * Create a new component instance.
     */
    public function __construct()
    {
        //
    }

    /**
     * Get the view / contents that represent the component.
     */
    public function render(): View|Closure|string
    {
        // Retrieve all users with the 'member' role
        $users = User::role('member')->get();

        // Initialize an array to hold score data for members
        $scoreList = [];

        // Loop through each user to calculate their scores
        foreach ($users as $user) {
            $scoreData = DB::table('users')
                ->select(
                    'users.username',
                    DB::raw('COALESCE(SUM(points.points), 0) AS total_points'),
                    DB::raw('COALESCE(SUM(CASE WHEN games.winner_id = users.id THEN 1 ELSE 0 END), 0) AS total_wins'),
                    DB::raw('COALESCE(SUM(CASE WHEN games.cup_winner_id = users.id THEN 1 ELSE 0 END), 0) AS total_cups'),
                    DB::raw('COUNT(game_user.game_id) AS total_games_played') // Count the total number of games played
                )
                ->leftJoin('game_user', 'game_user.user_id', '=', 'users.id')
                ->leftJoin('games', 'game_user.game_id', '=', 'games.id')
                ->leftJoin('points', function ($join) {
                    $join->on('points.user_id', '=', 'users.id')
                        ->on('points.game_id', '=', 'games.id');
                })
                ->where('users.id', $user->id) // Filter by the current user ID
                ->groupBy('users.id')
                ->first(); // Get the first result as each user should only appear once

            // Add score data to the scoreList array
            $scoreList[] = $scoreData;
        }

        return view('components.scorelist', compact('scoreList'));
    }
}

and this is the blade file

<div class="relative overflow-x-auto">
    <table class="w-full text-left rtl:text-right text-gray-500">
        <thead class="text-gray-700 uppercase bg-gray-50 text-xs">
        <tr>
            <th scope="col" class="px-4 py-3">Username</th>
            <th scope="col" class="px-4 py-3">G</th>
            <th scope="col" class="px-4 py-3">P</th>
            <th scope="col" class="px-4 py-3">W</th>
            <th scope="col" class="px-4 py-3">C</th>
        </tr>
        </thead>
        <tbody>
        @foreach($scoreList as $score)
            <tr class="bg-white border-b text-xs">
                <th scope="row" class="px-4 py-2 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                    {{ $score->username }}
                </th>
                <td class="px-4 py-2">
                    {{ $score->total_games_played }}
                </td>
                <td class="px-4 py-2">
                    {{ $score->total_points }}
                </td>
                <td class="px-4 py-2">
                    {{ $score->total_wins }}
                </td>
                <td class="px-4 py-2">
                    {{ $score->total_cups }}
                </td>
            </tr>
        @endforeach
        </tbody>
    </table>
</div>

the code above is functional. Now I want to make a livewire component with a pagination per user.

Livewire component:

<?php

namespace App\Livewire;

use App\Models\User;
use Illuminate\Support\Facades\DB;
use Livewire\Component;
use Livewire\WithPagination;

class Team extends Component
{
    use withPagination;

    public $scoreList = [];

    public function mount()
    {
        $users = User::role('member')->get();

        foreach ($users as $user) {
            $scoreData = DB::table('users')
                ->select(
                    'users.username',
                    DB::raw('COALESCE(SUM(points.points), 0) AS total_points'),
                    DB::raw('COALESCE(SUM(CASE WHEN games.winner_id = users.id THEN 1 ELSE 0 END), 0) AS total_wins'),
                    DB::raw('COALESCE(SUM(CASE WHEN games.cup_winner_id = users.id THEN 1 ELSE 0 END), 0) AS total_cups'),
                    DB::raw('COUNT(game_user.game_id) AS total_games_played') // Count the total number of games played
                )
                ->leftJoin('game_user', 'game_user.user_id', '=', 'users.id')
                ->leftJoin('games', 'game_user.game_id', '=', 'games.id')
                ->leftJoin('points', function ($join) {
                    $join->on('points.user_id', '=', 'users.id')
                        ->on('points.game_id', '=', 'games.id');
                })
                ->where('users.id', $user->id) // Filter by the current user ID
                ->groupBy('users.id')
                ->paginate(1); // Get the first result as each user should only appear once

            // Add score data to the scoreList array
            $this->scoreList[] = $scoreData;
        }
    }

    public function render()
    {
        return view('livewire.team', [
            'scoreList' => $this->scoreList,
        ]);
    }
}

It is almost the same code. Now I get the error: Undefined property: Illuminate\Pagination\LengthAwarePaginator::$username