问CakePHP 3.8 / CakePHP 4和CakePHP 2中原始查询结果的数组结构

EN

$sql = "SELECT u.id, u.firstname FROM users u, contacts c WHERE u.id = 2 and c.id = u.contact_id";
$u = $this->User->query($sql);  // Or on any other model...
$this->log($u);

Array
(
    [0] => Array
        (
            [u] => Array
                (
                    [id] => 2
                    [firstname] => MyFirstName
                )
            [c] => Array
                (
                    [zip] => 12345
                )

        )
)

$connection = ConnectionManager::get('default');
$sql = "SELECT u.id, u.firstname FROM users u, contacts c WHERE u.id = 1 and c.id = u.contact_id";
$u = $connection->execute($sql)->fetchAll();
$this->log($u);

Array
(
    [0] => Array
        (
            [0] => 2
            [1] => MyFirstName
            [2] => 12345
        )
)