在模型中连接查询方式
$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();
使用查询构建器创建查询