public function getList($where)
{
$res = db('order')->alias('o')
->join('admin', 'admin.id=o.uid', 'LEFT')
->join('client c', 'c.id=o.cid', 'LEFT')
->join('city ci','ci.id=c.area', 'LEFT')
->join('client_state cs', 'cs.id=c.state_id', 'LEFT')
->join('order_phases op', 'op.id=o.phases_id', 'LEFT')
->join('order_state os', 'os.id=o.state_id', 'LEFT')
->field('o.id,o.cid,o.uid,o.title,o.phases_id,o.state_id,admin.name as a_name,c.name as c_name,
c.area as c_area,c.state_id as c_state,c.service_id,ci.name as city_name,cs.state as cs_state,op.phases_title,os.state_title')

->paginate(10, false, ['query' => request()->param()]);
return $res;
}

client 这个表还要重复关联admin 怎么写
client.service_id = admin.id