我有以下查詢工作正常：SELECT core_condition AS name, NULL AS parentFROM condition_theme_lookupUNION ALLSELECT theme_name AS name, condition_theme_lookup.core_condition AS parentFROM theme, condition_theme_lookupUNION ALLSELECT strand.strand_name AS name, theme.theme_name AS parentFROM strandJOIN theme ON theme.theme_pk = strand.theme_fk結(jié)果數(shù)組，使用一些 PHP，生成以下 JSON，到目前為止還不錯，顯示了“主題”父母的“鏈”子代：{    "name": "Condition",    "children": [{        "name": "Professional",        "children": [{            "name": "Professional Behavours"        }, {            "name": "Self-Care and Self-Awareness"        }, {            "name": "Medical Ethics and Law"        }]    }, {        "name": "Leader",        "children": [{            "name": "Teamwork and Leadership"        }, {            "name": "Collaborative Practice"        }, {            "name": "Health Systems and Careers"        }]    }, {        "name": "Advocate",        "children": [{            "name": "Health Advocacy"        }, {            "name": "Aboriginal Health"        }, {            "name": "Diversity and Inequality"        }, {            "name": "Health Promotion"        }]    }, {        "name": "Clinician",        "children": [{            "name": "Scientific Knowledge"        }, {            "name": "Patient Assessment and Clinical Reasoning"        }, {            "name": "Patient Management"        }, {            "name": "Patient Perspective"        }, {            "name": "Clinical Communication"        }, {            "name": "Quality Care"        }]    }, {        "name": "Educator",        "children": [{            "name": "Life-Long Learning"        }, {            "name": "Mentoring Relationships"        }, {            "name": "Patient Education"        }, {            "name": "Teaching and Learning"        }, {            "name": "Assessment and Evaluation"        }]    },我現(xiàn)在想添加相同的孩子集：'Year 1'、'Year 2'、'Year 3' 和'Year 4'，從 tablestrand.year到每個strand.strand_name父母（例如職業(yè)行為、醫(yī)學(xué)倫理和法律等）。