php - 如何选择字段数组在一行中显示或在一行中显示json

Question

select 
       s.id,
       s.name,
       c.PNAME city,
       s.user_name,
       s.logo,
       sqrt(pow((latitude-'1'),2)+pow((longitude-'1'),2)) as distance ,
       (SELECT 
              ph.phone_number 
        FROM `phones` as ph 
        WHERE (ph.type='tel' AND ph.`shop_id`=s.id)) as phons
from shops as s
JOIN addresses  as a ON s.address_id=a.id 
JOIN city as c ON c.id=a.city
where 1
order by('distance ASC')
limit 0,20 ;

上面的代码给我一个错误:

Error code 1242, SQL state 21000: Subquery returns more than 1 row

Answer 1

    select s.id,s.name,
c.PNAME city,s.user_name,s.logo,
sqrt(pow((latitude-'1'),2)+pow((longitude-'1'),2)) as distance ,
((SELECT GROUP_CONCAT(ph.phone_number) FROM `phones` as ph WHERE (ph.type='tel'))) as phons
from shops as s
 JOIN addresses  as a ON s.address_id=a.id 
JOIN city as c ON c.id=a.city
where 1
order by('distance ASC')
limit 0,20 ;

GROUP_CONCAT reult numberphone in row