参考源代码：\yii\db\QueryBuilder::buildLikeCondition()

$cities = ['city1', 'city2', 'city3'];
$query = new \yii\db\Query();

$query->where(['or like', 'city', array_map(function ($item) {
    return $item.'%';
}, $cities), false]); 

print_r($query->createCommand()->rawSql);

// output: SELECT * WHERE `city` LIKE 'city1%' OR `city` LIKE 'city2%' OR `city` LIKE 'city3%'

只需使用SIMILAR TO in Postgres或REGEXP_LIKE in MySQL（取决于您的数据库引擎）而不是LIKE
例如，您的查询应如下所示：

$query->andWhere(['SIMILAR TO', 'city','('.implode('|', $arr).')%',false]);