<?php

$query="SELECT id, display, country FROM $table ";
$stmt = $pdo->prepare($query);
$stmt->execute();
while ($row=$stmt->fetch()) {
	$data3[$row['country']]['display'][$row['display']][]=$row['id'];
	}
}

$display=array(
"0"=>"На рассмотрении",
"1"=>"Утверждено",
"2"=>"Отклонено"
	);
?>

 <strong> Сводная таблица из БД</strong>
	// <div class="tot_registered"> Всего зарегистрированных: <span> <?php //echo count($data3['rows']); ?></span> </div>
    <div class="tot_countries"> Количество стран:   <span> <?php echo count($data['countries']); ?> </span> </div>
    <table class="table">

<tr>
	<th> Страна </th>
	<th> Всего </th>

			<?php foreach ($display as $key => $value): ?>
	<th> <?php echo $value;?> </th>
			<?php endforeach; ?>
</tr>

    <?php foreach ($data3 as $key => $country_data): ?> 
    	<tr> 
    		<td><? echo $key; ?> </td>
    		<td><? echo (count($country_data['display'],COUNT_RECURSIVE)-count($country_data['display'])); ?> </td>
    		<?php foreach ($display as $key => $value) { 
    			
    			if (isset($country_data['display'][$key])) {
    				$amount=count($country_data['display'][$key]);
    			}else {
    				$amount=0;
    			}
    			?>
    			<td><?php echo $amount; ?> </td>
    		
    		<?php	} ?>
    	</tr>	
    <?php endforeach; ?>
</table>