How to implement nested in yii2?

Question

Yii

Hello.
How can I implement this request?

SELECT * FROM `client` WHERE `subnet` IN (SELECT `id` FROM `subnet` WHERE `bras` = 2)

using "andFilterWhere" in Yii2?

Answer 1

if ($this->value) 
 $query->andWhere('`subnet` IN (SELECT `id` FROM `subnet` WHERE `bras` = :bras)',['bras'=>2])

how can it be done.

Answer 2

If there are models, then something like this:

$subnetQuery = Subnet::find();
$subnetQuery->andWhere(['bras' => 2]);

$clientQuery = Clint::find();
$clientQuery->andWehere(['in', 'subnet', $subnetQuery]);

//
$clientQuery->all();
//
$clientQuery->limit(1);
$clientQuery->one();

If not, then create instances of queries yourself and specify the necessary tables manually