How to get array: key from first column, value from second?

Question

PHP

Good afternoon! When executing a query like this:

$stmt->prepare("SELECT column_1, column_2 FROM table");
$stmt->execute();
$result_array = $stmt->fetchAll(PDO::FETCH_COLUMN | PDO::FETCH_GROUP);

We get an array of the form:

array {
  [column_1_value]=>
  array(1) {
    [0]=>
    string(8) "column_2_value"
  }
  [column_1_value]=>
  array(1) {
    [0]=>
    string(8) "column_2_value"
  }
  ...
}

This is not exactly what I need, but I need the following result:

array {
  [column_1_value]=> string(8) "column_2_value"
  [column_1_value]=> string(8) "column_2_value"
  ...
}

Answer 1

$stmt->fetchAll(PDO::FETCH_KEY_PAIR);