示例 使用substring_index和group_concat
SELECT
`a`.`id` AS `id`,
`a`.`room_id` AS `room_id`,
`b`.`group_name` AS `group_name`,
`b`.`building_name` AS `building_name`,
`b`.`type_name&#
示例 使用substring_index和group_concat
SELECT
`a`.`id` AS `id`,
`a`.`room_id` AS `room_id`,
`b`.`group_name` AS `group_name`,
`b`.`building_name` AS `building_name`,
`b`.`type_name&#