Hulp gezocht bij maken van kruistabel

function ou_r2mkruistabel (){
		global $connection;
		
		$where = NULL;
		if (isset($_GET['ou'])){
			$where = 'WHERE idm_person.ACHMEA_REF_OU = "'.mysqli_real_escape_string($connection, $_GET['ou']).'"';
		}
		
		$sqlUitlezen = mysqli_query($connection, "SELECT	
		CONCAT(idm_person.ACHMEA_CALLNAME, ' ', idm_person.MX_LASTNAME, ' <br>(', idm_person.ACHMEA_EMPLOYEENUMBER, ')' ) naam,
		idm_person2role.MSKEYVALUE_ROL rol

		
		FROM `idm_person`
			
		LEFT JOIN `idm_person2role` 
			ON idm_person.MSKEYVALUE_MEDEWERKER = idm_person2role.MSKEYVALUE_MEDEWERKER
			
		LEFT JOIN `idm_role`
			ON idm_role.MSKEYVALUE_ROL = idm_person2role.MSKEYVALUE_ROL

		".$where."

		ORDER BY idm_person2role.MSKEYVALUE_ROL, idm_person.MX_LASTNAME ASC
		");
		
		//---------------
		$sqlUitlezenOu = mysqli_query($connection, "SELECT 
		idm_person.DISPLAYNAME,
		idm_ou.MSKEYVALUE_OU,
		idm_ou.DISPLAYNAME
		
		FROM idm_person
		
		INNER JOIN `idm_ou` ON idm_person.ACHMEA_REF_OU = idm_ou.MSKEYVALUE_OU

		".$where." 
		");
		
		$sqlTelRecords = mysqli_num_rows($sqlUitlezen);
			$sqlAantal = $sqlTelRecords - 1;
		$sqlAantalOu = mysqli_num_rows($sqlUitlezenOu);
		if ($sqlAantalOu > 0){
			$sqlDataOu = mysqli_fetch_assoc($sqlUitlezenOu);
			
			echo '<table border="0" width="100%">';
			echo '<tr>';
			echo '<td align="center" valign="top" rowspan="3" width="100"><a href="javascript:javascript:history.go(-1)"><img src="../img/vorige_pagina_button.png" height="80"></td>';
			echo '<td valign="bottom"><h3>Rol / Medewerker koppelingen (matrix)</h3></td>';
			echo '</tr>';
			echo '<td valign="top"><h2>'.$sqlDataOu['DISPLAYNAME'].'</h2></td>';
			echo '</tr>';
			echo '<tr>';
			echo '<td colpan="2" align="right"><h6>Ik heb '.$sqlAantal.' rol / medewerker koppelingen gevonden op de afdeling <i>'.$sqlDataOu['DISPLAYNAME'].'</i></h6></td>';
			echo '</tr>';
			echo '</table>';
		}

		//---------------
		$sqlData = mysqli_fetch_all($sqlUitlezen, MYSQLI_ASSOC);
		
		if ($sqlAantal > 0){
			
			foreach($sqlData as $rij) {
			$namen[$rij['rol']] = $rij['rol'];
			$draai[$rij['naam']][$rij['rol']] = true;
			}
				echo '<table id="idmdata" border="1">' . PHP_EOL;
				echo '<tr>
						<th colspan="2"></th>';
							foreach($draai as $key=>$rol) {
								echo '<th>' . $key . '</th>';
							}
				echo '</tr>';
				
				echo '<tr>
						<td>Uniek kenmerk rol</td>
						<td>#</td>';
							foreach($draai as $key=>$rol) {
								echo '<td align="center"><font size="2"><b><i>'.count($rol).'</i></b></font></td>';
							}
				echo '</tr>';
				
				 
			foreach ($namen as $naam) {
				echo '<tr>
					<td>'. $naam . '</td>' . PHP_EOL;
				echo '<td>'.count($draai).'</td>';
						foreach($draai as $key=>$rol) { 
							if(isset($draai[$key][$naam])) {
								
								echo '<td align="center"><b>?</b></td>';
							}else{
								echo '<td></td>';
							}
						}
				echo '</tr>';
			}
				echo '</table>';
		}else{
			echo '<center><a href="javascript:javascript:history.go(-1)"><img src="../img/no-data.png"></a></center>';
		}		
	}

<?php
$roleCount = array();
foreach ($sqlData as $rij) {
    $namen[$rij['rol']] = $rij['rol'];
    $draai[$rij['naam']][$rij['rol']] = true;
    if (isset($roleCount[$rij['rol']]) === false) {
        $roleCount[$rij['rol']] = 0;
    }
    $roleCount[$rij['rol']]++;
}
?>