تالار گفتمان nCIS.ir

Kala::find()->where()->all();

http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#joining-with-relations

// SELECT `customer`.* FROM `customer`
// LEFT JOIN `order` ON `order`.`customer_id` = `customer`.`id`
// WHERE `order`.`status` = 1
// LEFT JOIN `book` ON `book`.`customer_id` = `customer`.`id`
// WHERE `book`.`status` = 1

$customers = Customer::find()
->leftJoin('order', '`order`.`customer_id` = `customer`.`id`')
->where(['order.status' => Order::STATUS_ACTIVE])
->leftJoin('book', '`book`.`customer_id` = `customer`.`id`')
->where(['book.status' => Book::STATUS_ACTIVE])
->all();