这张表里把经理的名字也加进去就可以了

SELECT *,

       CONCAT(ZRDATE, ',', zrequester_id, ',', ZPROD_TYPE) AS ZLONG

FROM loan_list

WHERE 1 = 1

  AND zrdate >= '${startdate}'

  AND zrdate <= '${enddate}'

  AND zrequester_id = (

      SELECT realName

      FROM fine_user

      WHERE   1=1

          ${if(username='经理',"","username = '"+fine_username+"'")}

  )

  /*${if(len(zprod_type) == 0,"","and zprod_type = '" + zprod_type + "'")}*/

ORDER BY zrdate DESC