$where = [
'name'=> 'aaa'
];
$whereOr = [
'phone' => 12345678999,
'email' => '11@qq.com',
];
$this->
->name('user')
->field('id,name,phone,email')
->where($where)
->whereOr(function($query) use ($whereOr){
$query->where($whereOr);
})
->select();
生成的语句是:
SELECT id,name,phone,email FROM `user` WHERE `name` = 'aaa' or (phone = '12345678999' and `email` = '11@qq.com');