CakePHP 3.x仅使用分页从当前用户查找记录

// src/Model/Table/UsersTable.php
namespace App\Model\Table;

use Cake\ORM\Table;

class UsersTable extends Table
{
    public function initialize(array $config)
    {
        $this->addBehavior('Timestamp');
    }

    public function findForUser($userId, $options = [])
    {
        return $this->find()
            ->where(['user_id' => $userId])
            ->order(['created' => 'DESC'])
            ->applyOptions($options);
    }
}

// src/Controller/UsersController.php
namespace App\Controller;

use App\Controller\AppController;
use Cake\ORM\TableRegistry;

class UsersController extends AppController
{
    public function initialize()
    {
        parent::initialize();
        $this->loadModel('Users');
    }

    public function index()
    {
        $userId = $this->Auth->user('id'); // 获取当前登录用户的 ID
        $this->paginate = [
            'finder' => ['forUser' => ['user_id' => $userId]],
            'limit' => 10, // 每页显示的记录数
            'page' => $this->request->getQuery('page', 1), // 当前页码
        ];

        $users = $this->paginate($this->Users);
        $this->set(compact('users'));
    }
}

<!-- src/Template/Users/index.ctp -->
<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($users as $user): ?>
            <tr>
                <td><?= h($user->id) ?></td>
                <td><?= h($user->name) ?></td>
                <td><?= h($user->email) ?></td>
            </tr>
        <?php endforeach; ?>
    </tbody>
</table>

<?= $this->Paginator->numbers() ?>
<?= $this->Paginator->counter(['format' => __('Page {{page}} of {{pages}}, showing {{current}} record(s) out of {{count}} total')]) ?>