tp51 where 和whereor同时使用

实现效果:

SELECT `ta`.*,u.nickname as u_name,u.avatar as u_pic,u.id as uid,`u`.`sy_summary` FROM zf_teacher_active ta INNER JOIN `bs_user` `u` ON `u`.`id`=`ta`.`tid` INNER JOIN `bs_school_user` `su` ON `su`.`uid`=`u`.`id` WHERE `ta`.`status` = 1 AND `su`.`status` <> 9 AND ( `ta`.`school` = '' OR `u`.`sy_ly` = '职场转型' OR `u`.`sy_ly` = '职场晋升') GROUP BY `u`.`id` ORDER BY `ta`.`id` DESC

$whereor[] = ['ta.school','=',$school];
$lys = explode(',',$ly);
foreach($lys as $k=>$vo){
    $whereor[] = ['u.sy_ly','=',$vo]; 
}
 $list = db('teacher_active ta')
                ->where($where)
                ->where(function ($query) use ($whereor) {
                    $query->whereOr($whereor);
                })
                ->field('ta.*,u.nickname as u_name,u.avatar as u_pic,u.id as uid,u.sy_summary')
                ->join(['bs_user'=>'u'],'u.id=ta.tid')
                ->join(['bs_school_user'=>'su'],'su.uid=u.id')
                ->order('ta.id desc')
                ->group('u.id')
                ->fetchSql(true)
                ->select();

->where($where)

->where(function ($query) use ($whereor) {

    $query->whereOr($whereor);

})