phalcon 连接查询(phql)

在模型中连接查询方式

$query = new \Phalcon\Mvc\Model\Query("SELECT A.id, A.name, A.age, A.address, B.name as bname FROM UserTest as A INNER JOIN robots B ON A.id=B.id WHERE A.id=:id:", $this->getDI());
        $data = $query->execute(['id' => 1])->toArray();

在控制器中查询方式

$this->modelsManager->executeQuery("SELECT * FROM UserTest")->toArray();

使用查询构建器创建查询