MYSQL数组聚合函数，例如PostgreSQL array_agg

MYSQL数组聚合函数，例如PostgreSQL array_agg

你想用

GROUP_CONCAt()

像

SELECt p.id, group_concat(pcb.users_admin_id) as uidFROM properties pINNER JOIN prop_captured_by pcb ON p.id = pcb.property_idgroup by p.id;