PHP System\Model User::join Examples

Example #1

File: Permission.php Project: houdunwang/hdcms

 public function users()
 {
     $User = new User();
     if (!service('user')->isManage()) {
         message('你没有站点的管理权限', 'back', 'error');
     }
     //获取除站长外的站点操作员
     $users = $User->join('site_user', 'user.uid', '=', 'site_user.uid')->where('role', '<>', 'owner')->andWhere('siteid', SITEID)->get();
     //站长数据
     $owner = service('user')->getSiteOwner(SITEID);
     return view()->with(['users' => $users, 'owner' => $owner]);
 }