public function get_customer_watchable_users($customer)
{
$customerID = MySQL::SQLValue($customer['customerID'], MySQL::SQLVALUE_NUMBER);
$p = $this->kga['server_prefix'];
$query = "SELECT * FROM {$p}users WHERE trash=0 AND `userID` IN (SELECT DISTINCT `userID` FROM `{$p}timeSheet` WHERE `projectID` IN (SELECT `projectID` FROM `{$p}projects` WHERE `customerID` = {$customerID})) ORDER BY name";
$result = $this->conn->Query($query);
return $this->conn->RecordsArray(MYSQLI_ASSOC);
}