php mysql逗号分隔的sql怎么取_php – MySQL逗号分隔值

我目前有一个sql和php问题,我使用这个语句来获取服务及其相关表的所有内容：

$db = $this->getDbo();

$query = $db->getQuery(true);

// Select the required fields from the table.

$query->select(

$this->getState(

'list.select', 'a.*'

)

);

$query->from('`#__services_service` AS a');

$query->where("a.zone");

$query->select('zone.name AS zone, zone.description AS zone_description, zone.price AS zone_price, zone.interval_recommended AS interval_recommended');

$query->join('LEFT', '#__services_zones AS zone ON zone.id = a.zone');

$query->select('category.icon AS category');

$query->join('LEFT', '#__services_categories AS category ON category.id = a.category');

但是在我加入的区域表中,有逗号分隔值’1,2′,并且在创建关联数组后,我将服务分组到它们的区域,单个服务仅转到单个区域,而不是表格中的值它应该在两个区域中都是’1,2’…我感觉这是因为’zone.name AS zone’,因为它只返回一个名称,如果我说’zone AS zone’它会返回逗号分隔数字…

这是我对数组进行排序的方式：

foreach( $this->items as $item ){

if( !isset( $zones[ $item->zone ] ) )

$zone_items[ $item->zone] = array();

$zone_items[ $item->zone ][] = $item;

$zones[$item->zone] = array(

'zone' => $item->zone,

'zone_interval' => $item->interval_recommended,

'zone_description' => $item->zone_description,

'zone_price' => $item->zone_price,

'items' => $zone_items[$item->zone]

);

}

我通过以下方式显示：

Interval Recommended

<?php //echo $items->category; ?>

<?php echo $items->name; ?>

<?php echo $items->description; ?>

only

任何帮助是极大的赞赏.

Services表如下所示：

和区域表：