id_, project_name_, project_short_name_, project_code_, project_type_, project_src_, project_nature_, project_belong_, project_address_, project_addvcd_, project_addvcd_name_, project_longitude_latitude_, project_map_, tax_rate_, project_situation_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, create_by_, create_name_, create_org_id_, create_org_full_id_, create_org_name_, create_dept_id_, create_dept_name_, create_dept_full_id_, create_time_, update_by_, update_name_, update_org_id_, update_org_name_, update_dept_id_, update_dept_name_, update_time_, is_dele_, last_time_, tenant_id_ SELECT o.id_ as id,o.name_ as name,o.code_ as code, o.org_kind_ as orgKind,o.parent_id_ as parentId FROM UC_ORG o WHERE o.IS_DELE_ = '0' and o.org_kind_='ogn' and o.PATH_ LIKE #{fullId} UNION all SELECT id_ as id,project_name_ as name,project_code_ as code, "project" as orgKind, belongs_org_id_ as parentId FROM biz_asset_business_project WHERE IS_DELE_ = '0'