$userlist=M('userlist');
$kaihushijian=$userlist->query('select kaihushijian from userlist group by kaihushijian');
foreach ($kaihushijian as $key => $value) {
$guanli=$userlist->query("select count(leixin) as num from userlist where leixin='管理员'and kaihushijian='$value[kaihushijian]' ");
$cguanli=$userlist->query("select count(leixin) as num from userlist where leixin='超级管理员'and kaihushijian='$value[kaihushijian]' ");
$yonghu=$userlist->query("select count(leixin) as num from userlist where leixin='用户'and kaihushijian='$value[kaihushijian]' ");
echo $value['kaihushijian']."-----";
foreach ($guanli as $key2 => $value2) {
echo $value2['num']."-";
}
foreach ($cguanli as $key3 => $value3) {
echo $value3['num']."-";
}
foreach ($yonghu as $key4 => $value4) {
echo $value4['num']."<br>";
}
} 最佳答案
