20,398
社区成员




$sql="SELECT c.*,GROUP_CONCAT(a.label_name) AS sport FROM a INNER JOIN b ON a.label_id=b.label_id INNER JOIN c ON b.uid=c.uid WHERE b.uid IN(
SELECT b.uid FROM a INNER JOIN b ON a.label_id=b.label_id WHERE a.label_id = 1
) GROUP BY uid";
M()->query($sql);