select v.patient_name,json_object("name",d.item_name,"code",d.item_code) from op_advice_master v join op_advice_detail d on d.advice_id=v.id
SELECT org_id,org_name,dept_name,doctor_id,doctor_name,json_array(group_concat(json_object("visitNo",visit_no,"collectId",collect_id) SEPARATOR ','))
FROM `op_visit_record` where doctor_id='641147635269632' and register_type_code='3'