BIM-Monitor/script/php/get_sites.php

<?php
include("./connect_sql.php");
$ajax = [];
$sql = "SELECT [Site_List].[SiteID],[SiteName],[ModelID] FROM [Site_List]
JOIN [Site_Data] ON [Site_List].[SiteID] = [Site_Data].[SiteID];";

$stmt = sqlsrv_query($conn, $sql);

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    if(!isset($ajax[$row["SiteID"]])) {
        $ajax[$row["SiteID"]] = [];
        $ajax[$row["SiteID"]]["SiteName"] = $row["SiteName"];
        $ajax[$row["SiteID"]]["ModelID"] = [];
    }

    array_push($ajax[$row["SiteID"]]["ModelID"], $row["ModelID"]);
}
if ($stmt === false) {
    if (($errors = sqlsrv_errors()) != null) {
        foreach ($errors as $error) {
            echo "SQLSTATE: " . $error['SQLSTATE'] . "<br />";
            echo "code: " . $error['code'] . "<br />";
            echo "message: " . $error['message'] . "<br />";
            echo ($sql . "<br />");
            var_dump($row);
        }
    }
}


echo (json_encode($ajax));