循环和排序结果没有重复

Question

Can you suggest me what will be the good way to convert result without duplication?

$numbers = array ('1', '5', '10');
 foreach ($numbers as $number){
  $query[] = $this->db->query("SELECT name, country FROM name WHERE id= '" . (int)$number .'"")
 }

Result

 Array (
  Array (
   name = ivan
   country = en
  )
  Array(
   name = Peter
   country = en
  )
  Array (
   name = sisi's
   country = en
  )
 )

How can I sort result like this

  Array(
   country = en
   name = array (
     sisi's
     Peter
     Ivan
   )
 )

Answer 1

You need to modify your query.

$numbers = array ('1', '5', '10');

$sql = "SELECT DISTINCT country,
GROUP_CONCAT(name) AS name
FROM name 
WHERE id IN(".implode(',',$numbers).")
GROUP BY country";

$this->db->query($sql);

Than after getting the result, you can convert the string names into array with explode function.