skdroid

首先,使用

SELECT id, name FROM table SOME CONDITIONS

此查询将返回如下结果

$result = [
  [ id => 1, name => 'name' ],
  [ id => 1, name => 'name' ],
  [ id => 1, name => 'name' ],
  [ id => 1, name => 'name' ],
]

然后排列数组

$accepted_output = array_column($result, 'id', 'name')

$accepted_output  = [
  [ 1 =>  'name' ],
  [ 1 =>  'name' ],
  [ 1 =>  'name' ],
  [ 1 =>  'name' ],
]

数组列文档- https://www.php.net/manual/en/function.array-column.php