UserViewsExecutionHooks.php

<?php

namespace Drupal\user\Hook;

use Drupal\views\ViewExecutable;
use Drupal\Core\Hook\Attribute\Hook;

/**
 * Hook implementations for user.
 */
class UserViewsExecutionHooks {
    
    /**
     * Implements hook_views_query_substitutions().
     *
     * Allow replacement of current user ID so we can cache these queries.
     */
    public function viewsQuerySubstitutions(ViewExecutable $view) {
        return [
            '***CURRENT_USER***' => \Drupal::currentUser()->id(),
        ];
    }

}