[SQL] pobierz, plaintext 
SELECT id,t,count(*) AS cnt FROM tabela GROUP BY t;
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$array = array ( 0 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 1 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 2 => array ( 'id' => '2', 't' => 'Automotive', ), );
 
$return = array();
$count = array();
foreach( $array as $item ) {
    if ( !in_array($item, $return) ) {
        $return[] = $item;
        $count[ $item['id'] ] = 1;
    } else {
        $count[ $item['id'] ]++;
    }
}
 
foreach( $return as & $item ) {
    $item['cnt'] = (int)$count[ $item['id'] ];
}
 
var_dump( $return );
[PHP] pobierz, plaintext