shabaz-ejaz/Join query.php

## Join query.php
 $products = AirtablesProduct:: find()
            ->with('airtablesProductsTypes.airtablesProductType')
            ->with('airtablesProductsComponents.airtablesComponent')
            ->with('airtablesProductsSizes.airtablesProductSize')
            ->with('airtablesProductsSpecies.airtablesSpecie')
            ->orderBy('name ASC')
            ->asArray();

## join table and count records.php
return static::find()->where(['user_referred_by' => $this->id ])->andWhere(['NOT',['user_subscription.id' => null]])->joinWith('subscription')->asArray()->count(); die;

## join tables with activerecord
https://stackoverflow.com/questions/28525945/retrieve-data-from-junction-table-in-yii2
	$products = AirtablesProduct:: find()
	->with('airtablesProductsTypes.airtablesProductType')
	->with('airtablesProductsComponents.airtablesComponent')
	->with('airtablesProductsSizes.airtablesProductSize')
	->with('airtablesProductsSpecies.airtablesSpecie')
	->orderBy('name ASC')
	->asArray();