有的时候你可能会用到查一次查询返回若干个结果,在php里现在不是什么难题了。 $rows = array (); $db = new mysqli('127.0.0.1','root','123456','user'); if (mysqli_connect_errno()){ $this->message('Can not connect to MySQL server'); } $db->query("SET NAMES UTF8"); $query = "select * from `user`.`user` limit 0, 50;"; $query .= "select count(0) as `count` from `user`.`user`"; if($db->multi_query($query)){ do{ if($result = $db->store_result()){ while ($row = $result->fetch_assoc()){ array_push($rows, $row); } $result->close(); } }while($db->next_result()); } $db->close();