【LEFT JOIN 入门级实践】项目表与组织表与人员表，其中人员存在上下级关系

SELECT    P .*, org.orguuid AS orgUuid,    org.cnName AS cnName,    person.full_name AS addPersonName,    person2.full_name AS personLeaderNameFROM    RECTIFY_PROJECT PLEFT JOIN sys_org org ON org.orguuid = P .officesidLEFT JOIN ro_person person ON person.personuuid = P .hoder_uuid--再次左连接 ro_person表， 两个人员表 通过别名（person/person2）来区分LEFT JOIN ro_person person2 ON person2.personuuid = P .org_leader_uuidWHERE    1 = 1AND P .is_del != 1AND P .parent_project_uuid = ''AND P .project_Uuid = ?ORDER BY    P .project_rectify_state ASC,    P .add_time DESC