Calc cube

$result = mysqli_query($link, "SELECT box, count(id) FROM table WHERE cube='red' GROUP BY box") ;
while ($row = mysqli_fetch_array($result)) {
    echo "$row[0] $row[1]";
}