How to properly pack a hierarchically merged construction in Yii2 (with or join)?

Question

Yii

Good afternoon, there is such a request:
(get products related to the category and its descendants)

$products = Products::findBySql("
            SELECT
                *
            FROM
                m_products
            WHERE
             category_id
            IN (
                SELECT
                    id
                FROM
                    t_products
                WHERE
                    lft >= '{$model->lft}'
                AND
                    rgt <= '{$model->rgt}'
            )
            "
        )->andWhere([
            'exist'=>PublicActiveRecord::EXIST_PUBLIC
        ])->all();

I want to do it more correctly in yii2 without sql?
In theory, you can somehow get a list of category identifiers in an array:
array_merge([$category->id], $category->children()->select('id')->column())
But these are only categories, you need how to get goods.
I'll have to make 1 more request with in
Tell me - how to do it right, maybe through with , relation scope or something else?

Answer 1

$categories = Category::find()
            ->where(['>=', 'lft', $model->lft])
            ->andWhere(['<=', 'rgt', $model->rgt])
            ->with('products')
            ->all();

Connection:

public function getProducts()
    {
        return $this->hasMany(Product::className(), ['category_id' => 'id']);
    }

The array will contain categories with products