可以写个虚表,这个可以简化为 

${if(administrators="管理员","","and privilege_ctl in (SELECT A FROM B)")}

写法不对，参考下面

${if(administrators="管理员","","and privilege_ctl in (

   SELECT 

   CONCAT(a.industry_name,a.corp_name,a.sale_area_code_desc,a.customer_corp_name) qx

   from (

   SELECT

  t2.user_name,

  t1.industry_name,

        t1.corp_name,

        t1.sale_area_code_desc,

        t1.customer_corp_name

  FROM ( 

    SELECT

        DISTINCT industry_code,

        industry_name,

        corp_code,

        corp_name,

        sale_area_code,

        sale_area_code_desc,

        customer_corp_code,

        customer_corp_name 

    FROM

        dim_corp_customer_relation

  ) t1 join (select * from write_user_permissions) t2 

  on t1.corp_name=t2.corp_code

  and t1.sale_area_code_desc=t2.sale_area_code

  and t1.customer_corp_name=t2.customer_corp_code

  and t1.industry_name=t2.industry_code

   where t2.user_name='"+user_name+"')")}