Yii2: How to pull cities by condition?

Question

Yii

Got something wrong, guys. there are 2 models. City and Club (there are many clubs in the city. Club 1 to the city)
in short, you need to display all cities from known clubs.
made by the city

public function getClubs(){
    return $this->hasMany(Club::className(), ['city_id'=>'id']);
  }

asking

$_cities = City::find()->joinWith('clubs')->where(['LIKE', 'name_ru', $term])->all();

displays all the cities that fall under the where condition
that I forgot to specify for the join, so that it displays only specific cities of famous clubs?
there are only 3 clubs. in ekb, moscow and petersburg

Answer 1

$_cities = City::find()->joinWith('clubs', true, 'INNER JOIN')->where(['LIKE', 'net_city.name_ru', $term])->all();

Answer 2

Two tables connected via hasMany:
a) cart --- Cart
b) goods --- Goods
$result = (new \yii\db\Query())
->select([])
->from([ 'cart'])
->innerJoin(['goods'])
->where(['cart_ip' => $_SERVER['REMOTE_ADDR']])
->andWhere('`cart_good_id` = `goods_id`')
-> groupBy(['cart_good_id'])
->all();
return $this->render('index',['result' => $result]);
<?php foreach ( $result as $row):