model()->select('a.gprice,a.is_state,b.name')->from('userprice a')->left('acc b')->on('a.channelid=b.id')->join()->where(array('fields' => 'userid=?', 'values' => array($_SESSION['login_agentid'])))->fetchAll(); $data = array('title' => '代理费率', 'userprice' => $userprice); $this->put('rates.php', $data); } }