Sort table by column via mysql and php?

Question

PHP

There is a table in the database

How to get this in PHP?
Fruit:
Apple
Pear
Orange
Vegetable:
Tomato
Cucumber
Onion
The problem is in sorting on PCP, I know how to get data from the database..

Answer 1

select * from my_table ORDER BY my_column

Answer 2

function cmp($a, $b)
{
    return strcmp($a["cat"], $b["cat"]);
}
usort($arr, "cmp");

Answer 3

$arr = [];
foreach ($res as $k=>$val) {
    if (!array_key_exist($val['type'], $arr)) {
         $arr[$val['type']] = [];
    }
    $arr[$val['type']][] = $val['name'];
}

Get an associative array broken down by type.