mysql complex query

$s = "SELECT LEFT(room,1) as room_floor GROUP_CONCAT(room) as g_room FROM tb WHERE status='on' GROUP BY LEFT(room,1)";
$r = mysql_query($s);
while($row = mysql_fetch_assoc($r)){
echo $row['room_floor'],...,$row['g_room'];

}