Filter not apply for the pivot table

use Filament\Forms\Components\Select;
use Filament\Tables\Filters\Filter;
use Illuminate\Database\Query\JoinClause;
use Illuminate\Support\Facades\Log;

return Filter::make(name: 'posts.post_user.role')
    ->form(schema: [
        Select::make(name: 'post_role')
            ->options(options: PostRoleEnum::class),
    ])
    ->query(callback: function (Builder $query, array $data) use ($post): Builder {
        return $query
            ->when(
                $data['post_role'],
                callback: function (Builder $query, $role) use ($post): Builder {
                    $query2 = $query->join(table: 'post_user', first: function (JoinClause $join) use (
                        $post, $role
                    ): void {
                        $join->on(first: 'users.id', operator: '=', second: 'post_user.user_id')
                            ->where(
                                column: 'post_user.post_id',
                                operator: '=',
                                value: $post->id,
                            )->where(column: 'post_user.role', operator: '=', value: $role);
                    });

                    //value in the log is correct but why filter not refresh data, I have no idea
                    Log::info(message: 'role', context: ['sql' => $query2->toRawSql()]);

                    return $query2;
                },
            );