id_, name_, parent_id_, order_no_, code_, grade_, path_, path_name_, dem_id_, update_time_, is_dele_, version_, limit_num_, now_num_, exceed_limit_num_, create_by_, create_org_id_, create_time_, update_by_, org_kind_ SELECT * FROM biz_company ${ew.customSqlSegment} select ID_ ,PARENT_ID_,NAME_,CODE_, ( case (select count(*) from UC_ORG p where p.PARENT_ID_=o.ID_ and p.ID_!=p.PARENT_ID_ AND p.IS_DELE_!='1') when 0 then 0 else 1 end )isIsParent from UC_ORG o where PARENT_ID_=#{pid} AND IS_DELE_!='1' AND org_kind_ = 'ogn' order by ORDER_NO_ asc