模糊查询多表内容（查询某张表的值为另一张表的查询条件）

$condition['open_id'] = array ( 'exp', "=some(select open_id from user_type where wxname like '%" . $value . "%')" );
//模糊查询user_type中输入的微信名称（wxname）的opend_id让其为in的某个key的值，再次查询
$result = $this->salesman->whereSalesman($condition);