ID_, MAT_SHORT_NAME_, MAT_TYPE_, MAT_ID_, MAT_CODE_, PARENT_ID_, PARENT_MAT_ID_, PARENT_MAT_CODE_, SUPPLIER_ID_, SUPPLIER_CODE_, SUPPLIER_NAME_, NOTES_, SN_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, TENANT_ID_, VERSION_ select ma1.ID_, ma1.MAT_SHORT_NAME_, ma1.MAT_TYPE_, ma1.MAT_ID_, ma1.MAT_CODE_, ma1.PARENT_ID_, ma1.PARENT_MAT_ID_, ma1.PARENT_MAT_CODE_, ma1.SUPPLIER_ID_, ma1.SUPPLIER_CODE_, ma1.SUPPLIER_NAME_, ma1.NOTES_, ma1.SN_, m1.MAT_PLATCODE_, m1.MAT_CATEGORY_, m1.MAT_NAME_, m1.MAT_MATERIAL_, m1.MAT_SPEC_ , m1.MAT_UNIT_, m1.MAT_BRAND_, m1.MAT_BASE_EXT_, m1.MAT_OTHER_EXT_, m1.MAT_TAXRATE_ from biz_material_hierarchical_management ma1 LEFT JOIN biz_material m1 on ma1.MAT_ID_ = m1.ID_ WHERE ma1.MAT_TYPE_ = 1 and ma1.IS_DELE_ = '0' and ma1.PARENT_ID_='root' UNION ALL select ma2.ID_, ma2.MAT_SHORT_NAME_, ma2.MAT_TYPE_, ma2.MAT_ID_, ma2.MAT_CODE_, ma2.PARENT_ID_, ma2.PARENT_MAT_ID_, ma2.PARENT_MAT_CODE_, ma2.SUPPLIER_ID_, ma2.SUPPLIER_CODE_, ma2.SUPPLIER_NAME_, ma2.NOTES_, ma2.SN_, m2.MAT_PLATCODE_, m2.MAT_CATEGORY_, m2.MAT_NAME_, m2.MAT_MATERIAL_, m2.MAT_SPEC_ , m2.MAT_UNIT_, m2.MAT_BRAND_, m2.MAT_BASE_EXT_, m2.MAT_OTHER_EXT_, m2.MAT_TAXRATE_ from biz_material_hierarchical_management ma2 LEFT JOIN biz_plat_material m2 on ma2.MAT_ID_ = m2.ID_ WHERE ma2.MAT_TYPE_ = 2 and ma2.IS_DELE_ = '0' and ma2.PARENT_ID_='root' ${ew.customSqlSegment} select ma1.ID_, ma1.MAT_SHORT_NAME_, ma1.MAT_TYPE_, ma1.MAT_ID_, ma1.MAT_CODE_, ma1.PARENT_ID_, ma1.PARENT_MAT_ID_, ma1.PARENT_MAT_CODE_, ma1.SUPPLIER_ID_, ma1.SUPPLIER_CODE_, ma1.SUPPLIER_NAME_, ma1.NOTES_, ma1.SN_, m1.MAT_PLATCODE_, m1.MAT_CATEGORY_, m1.MAT_NAME_, m1.MAT_MATERIAL_, m1.MAT_SPEC_ , m1.MAT_UNIT_, m1.MAT_BRAND_, m1.MAT_BASE_EXT_, m1.MAT_OTHER_EXT_, m1.MAT_TAXRATE_ from biz_material_hierarchical_management ma1 LEFT JOIN biz_material m1 on ma1.MAT_ID_ = m1.ID_ WHERE ma1.MAT_TYPE_ = 1 and ma1.IS_DELE_ = '0' and ma1.PARENT_ID_=#{parentId} UNION ALL select ma2.ID_, ma2.MAT_SHORT_NAME_, ma2.MAT_TYPE_, ma2.MAT_ID_, ma2.MAT_CODE_, ma2.PARENT_ID_, ma2.PARENT_MAT_ID_, ma2.PARENT_MAT_CODE_, ma2.SUPPLIER_ID_, ma2.SUPPLIER_CODE_, ma2.SUPPLIER_NAME_, ma2.NOTES_, ma2.SN_, m2.MAT_PLATCODE_, m2.MAT_CATEGORY_, m2.MAT_NAME_, m2.MAT_MATERIAL_, m2.MAT_SPEC_ , m2.MAT_UNIT_, m2.MAT_BRAND_, m2.MAT_BASE_EXT_, m2.MAT_OTHER_EXT_, m2.MAT_TAXRATE_ from biz_material_hierarchical_management ma2 LEFT JOIN biz_plat_material m2 on ma2.MAT_ID_ = m2.ID_ WHERE ma2.MAT_TYPE_ = 2 and ma2.IS_DELE_ = '0' and ma2.PARENT_ID_=#{parentId} ${ew.customSqlSegment}