CakePHP 3对联合查询的结果进行分页

// In src/Model/Table/ArticlesTable.php
$this->belongsTo('Users', [
    'foreignKey' => 'user_id',
    'joinType' => 'INNER',
]);

// In src/Controller/ArticlesController.php
public function index()
{
    $this->loadComponent('Paginator');

    // Create the query with a join
    $query = $this->Articles->find()
        ->contain(['Users']) // Use contain to include associated Users data
        ->select([
            'Articles.id',
            'Articles.title',
            'Articles.created',
            'Users.username'
        ]);

    // Paginate the query
    $articles = $this->Paginator->paginate($query);

    // Set the paginated results to the view
    $this->set(compact('articles'));
}

// In src/Controller/ArticlesController.php
public function index()
{
    $this->loadComponent('Paginator');

    // Create the query with a join
    $query = $this->Articles->find()
        ->contain(['Users']) // Use contain to include associated Users data
        ->select([
            'Articles.id',
            'Articles.title',
            'Articles.created',
            'Users.username'
        ]);

    // Configure pagination settings
    $this->paginate = [
        'limit' => 10, // Number of records per page
        'order' => [
            'Articles.created' => 'desc'
        ]
    ];

    // Paginate the query
    $articles = $this->Paginator->paginate($query);

    // Set the paginated results to the view
    $this->set(compact('articles'));
}

// In src/Template/Articles/index.ctp
<table>
    <thead>
        <tr>
            <th>Title</th>
            <th>Author</th>
            <th>Created</th>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($articles as $article): ?>
        <tr>
            <td><?= h($article->title) ?></td>
            <td><?= h($article->user->username) ?></td>
            <td><?= h($article->created) ?></td>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>

<div class="paginator">
    <ul class="pagination">
        <?= $this->Paginator->first('<< ' . __('first')) ?>
        <?= $this->Paginator->prev('< ' . __('previous')) ?>
        <?= $this->Paginator->numbers() ?>
        <?= $this->Paginator->next(__('next') . ' >') ?>
        <?= $this->Paginator->last(__('last') . ' >>') ?>
    </ul>
    <p><?= $this->Paginator->counter(__('Page {{page}} of {{pages}}, showing {{current}} record(s) out of {{count}} total')) ?></p>
</div>

debug($articles);