private function get_site_relations_from_query_results(array $rows)
{
$relations = array_reduce($rows, function (array $relations, array $row) {
$site_1 = (int) $row['site_1'];
$site_2 = (int) $row['site_2'];
$relations[$site_1][$site_2] = $site_2;
$relations[$site_2][$site_1] = $site_1;
return $relations;
}, []);
return array_map('array_values', $relations);
}