How to sum values ​​with same names?

Question

MySQL

By referring to MySQL with a specific query, I get an array with the values ​​​​of different tables. Can I change my query so that instead of two repeating array elements with the name "Food and Drinks" I get one element, where the amount of elements with the repeating name will be summed up? It turns out I want the array to have an element with the name "Food and Drinks", where amount = "700".

Answer 1

Group by name and sum(amount)

Answer 2

Collection->pluck('name')->sum()

Answer 3

You can also call array_combine([id,name], array_map(null, $result)) and instead get

[
  0 => [ id => 1, name => 'vasya' ],
  1 => [ id => 2, name => 'petya' ],
]

array

[
  id => [ 1,2 ],
  name => [ vasya, petya ],
]

summarize later, filter what you want to do