For usage in your controller.

IN-YOUR-CONTROLLER-yii-row-check.php

<?php

$provider_ids = Provider::find()
                            ->select(['id'])
                            ->where(['parent_id' => $parent_provider_id]);

$num_providers = $provider_ids->count();

if($num_providers > 0){
  $arr_provider = $provider_ids
                                ->asArray()
                                ->each();
                                
  return $this->render('my_template', [
      'providers' => $arr_provider
    ]);
}