Cacher is the code snippet organizer for pro developers

$query = Provider::find()->joinWith([
  'redirectTo' => function($q){
    $q->from('providers providersAlias');
  }
]);