Как соединить четыре SQL-запроса в один?

// $type = '1';
// $model = 'ABARTH';
// $model = '500';
// $capacity = '1400';

    function getECUTypes($type, $brand, $model, $capacity) {

      $dbc = self::getConnection();

      $query = "SELECT `auto_sel_brand_id` FROM `auto_sel_brand` WHERE `auto_sel_brand_name` = '$brand' AND `auto_sel_brand_type` = '$type'";

      $result = $dbc->query($query) or DIE($dbc->error);

      $rows = $result->fetch_assoc();

      $brand_id = $rows['auto_sel_brand_id'];

      $query = "SELECT `auto_sel_model_id` FROM `auto_sel_model` WHERE `auto_sel_model_name` = '$model' AND `auto_sel_model_brand` = '$brand_id'";

      $result = $dbc->query($query) or DIE($dbc->error);

      $rows = $result->fetch_assoc();

      $model_id = $rows['auto_sel_model_id'];

      $query = "SELECT `auto_sel_ecu_id` FROM `auto_sel_motor` WHERE `auto_sel_ecu_motor` = '$model_id' AND `auto_sel_ecu_name` = '$capacity'";

      $result = $dbc->query($query) or DIE($dbc->error);

      $rows = $result->fetch_assoc();

      $ecu_id = $rows['auto_sel_ecu_id'];

      $query = "SELECT `auto_sel_motor_name` FROM `auto_sel_ecu` WHERE `auto_sel_motor_model` = '$ecu_id'";

      $result = $dbc->query($query) or DIE($dbc->error);

      $result_array = [];
      while ($rows = $result->fetch_assoc()) {
          array_push($result_array, $rows);
      }

      return $result_array;

    }