/** * 添加、修改公众号 */ public function actionModify($id) { $id = (int) $id; $GhMenu = new GhMenu(); $this->data = $GhMenu->select('m.*,a.gh_name')->from('gh_menu m')->join('gh_manage a', 'm.gid=a.gid')->where(array('m.mid' => $id))->getAll(); $GhManage = new GhManage(); $this->wxdata = $GhManage->select('gid,gh_name')->where('userid=' . $this->userinfo['userid'])->notin('gid NOT IN(SELECT gid FROM gh_menu)')->getAll(); }