ID_, COMPANY_CODE_, COMPANY_NAME_, COMPANY_SHORT_NAME_, COMPANY_TYPE_, COMPANY_ADDRESS_, COMPANY_MAN_, COMPANY_TEL_, COMPANY_FAX_, COMPANY_MAIL_, MEMO_, SN_, IS_DELE_, CREATE_BY_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, VERSION_, LAST_TIME_ SELECT c.id_,c.COMPANY_NAME_ as name,0 as parentId,1 as type FROM device_base_company c WHERE c.IS_DELE_ = 0 and c.COMPANY_TYPE_ like concat('%',#{vo.companyType},'%') and c.COMPANY_CODE_ like concat('%',#{vo.companyCode},'%') and c.COMPANY_NAME_ like concat('%',#{vo.companyName},'%') UNION all SELECT u.id_,u.NAME_,u.COMPANY_ID_ as parentId, 2 as type FROM device_base_user u LEFT JOIN device_base_company c on c.ID_ = u.COMPANY_ID_ WHERE c.IS_DELE_ = 0 and u.IS_DELE_ = 0 and c.COMPANY_TYPE_ like concat('%',#{vo.companyType},'%') and c.COMPANY_CODE_ like concat('%',#{vo.companyCode},'%') and c.COMPANY_NAME_ like concat('%',#{vo.companyName},'%')