'category_id'
обозначьте псевдоним. ->joinWith([
'city' => function(ActiveQuery $query){
$query->from(['rc1' => Cities::tableName()]);
}
])
t.category_id
(`p`.`category_id`='1') AND (`p2.category_id` IN ('1', '6', '7', '8'))