feat0806: 诊所详情多用户时报错

hejianhao

2026-08-19 63ceaf826f0e9077b01f1eb618d0ea5bdf7d043e

feat0806: 诊所详情多用户时报错

 tcm-training-admin-backend/src/main/resources/mapper/ClinicQueryMapper.xml

@@ -129,7 +129,7 @@
               u.phone AS loginAccount, u.avatar AS avatar,
               COUNT(u.id) AS userCount
        FROM tcm_clinic c
        LEFT JOIN tcm_app_user u ON u.clinic_id = c.id AND u.deleted = 0
        LEFT JOIN tcm_app_user u ON u.clinic_id = c.id AND u.deleted = 0 and u.type = 1
        WHERE c.deleted = 0 AND c.id = #{id}
        GROUP BY c.id, c.name, c.contact_phone, c.address, c.business_license_url,c.status,
                 c.bank_name, c.account_holder, c.account_number, c.branch_name, u.avatar, u.phone