field('U.id,U.pic,U.email,U.user,U.phone,U.name as uname,U.vip,U.reg_time,U.ban,A.name as appname,IFNULL(L.zx,0) as zai')->JOIN('app','as A','U.appid=A.id')->JOIN("(SELECT uid,COUNT(*) AS zx FROM `{$DP}user_logon` where `last_t` > {$UTT} GROUP BY uid) AS L",'U.id=L.uid'); if($so != ''){ $user = $user->where('A.name','like',"%{$so}%")->whereOr('U.id','like',"%{$so}%")->whereOr('U.appid','like',"%{$so}%")->whereOr('U.user','like',"%{$so}%")->whereOr('U.email','like',"%{$so}%")->whereOr('U.phone','like',"%{$so}%")->whereOr('U.name','like',"%{$so}%")->order('id desc'); }else{ $user = $user->order('id desc')->limit($bnums,$ENUMS); } $res = $user->select();//false //die($res); foreach ($res as $k => $v){$rows = $res[$k]; ?>

	UID	账号	用户组	应用名	注册时间	在线设备	账号状态	管理
			time() || $rows['vip']=='999999999'): ?>会员用户普通用户	应用不存在			0):?>禁封正常