id_, org_id_, org_name_, evaluation_time_, level_, year_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT u.id_ AS userId, u.fullname_ AS userName,o.parent_id_,o.path_, ou.org_id_, o.name_ AS name, ue.year_, ue.level_,ou.is_charge_ FROM uc_user u LEFT JOIN uc_org_user ou ON ou.user_id_ = u.id_ LEFT JOIN uc_org o ON o.id_ = ou.org_id_ LEFT JOIN exam_user_evaluation ue ON ue.user_id_ = u.id_ WHERE ue.year_ = #{year} AND ou.org_id_ IS NOT NULL SELECT o.id_, o.parent_id_, o.path_ as fullId, o.path_name_ as fullName, o.name_ AS name, o.code_ FROM uc_org o WHERE o.is_dele_ != '1'