1、$rsm ~~~ $rsm = new ResultSetMapping(); # $rsm->addScalarResult($columnName, $alias, type="string"); $rsm->addScalarResult('name', 'name'); $rsm->addScalarResult('password', 'password'); ~~~ 2、$sql ~~~ $sql = "SELECT t.name t.password FROM table t where t.id < 100 GROUP BY t.role"; ~~~ 3、$query ~~~ $query = $em->createNativeQuery($sql, $rsm); ~~~ 4、$qr ~~~ $qr = $query->getResult(); ~~~