How to display data from the database in the form of such an array?

Question

PHP

There is a database, like this:

How to display this data in such an array:

[
    'id' => 1,
    'name' => 'name1',
    'desc' => '1desc',
  ],
  [
    'id' => 2,
    'name' => 'name2',
    'desc' => '2desc',
  ],
  ];

Answer 1

select `id`, `name`, `desc` from table
var_dump($result)