Create a view table based on a query #drupal8

view-query-based.php

public function displayListDownloads()
  {


    $header = array(
        array('data' => t('Name'), 'field' => 'name'),
        array('data' => t('File ID'), 'field' => 'download_file__target_id'),
    );

    // Retrieve accessible location id by the user
    $user = User::load(\Drupal::currentUser()->id());
    $tempList = $user->get('field_user_sites')->referencedEntities();

    $sitesId = array();
    if (count($tempList) > 0) {
      foreach ($tempList as $site) {
        $sitesId[] = $site->id();
      }
    }

    $query = \Drupal::database()->select('download_forecast','download');
    $query->distinct(true);
    $query->leftJoin('download_forecast__physical_location','location','location.entity_id = download.id');
    $query->fields('download',['name' , 'download_file__target_id']);
    $query->condition('location.physical_location_target_id',$sitesId,'IN');

    $fileManagedListArray = $query->execute()->fetchCol(1);


    $table_sort = $query->extend('Drupal\Core\Database\Query\TableSortExtender')->orderByHeader($header);
    $pager = $table_sort->extend('Drupal\Core\Database\Query\PagerSelectExtender')->limit(1);
    $result = $pager->execute();


    foreach($result as $row) {
      $rows[] = array('data' => (array) $row);
    }

    $build = array(
        '#markup' => t('List of All locations')
    );

    $build['location_table'] = array(
        '#theme' => 'table', '#header' => $header,
        '#rows' => $rows
    );
    $build['pager'] = array(
        '#type' => 'pager'
    );

    return $build;

  }