mysql8.0在使用(${valueIdStr})时报错，在线求大佬帮忙解答下

SELECT
ba.,ba.id as ba_id,bv.,bv.id as bv_id
FROM
pms_base_attr_info ba,
pms_base_attr_value bv
WHERE
ba.id = bv.attr_id
and
bv.id in (${valueIdStr})

报错：

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 9

The error may exist in file [F:\yuan\gmall-manage-service\target\classes\mapper\PmsBaseAttrInfoMapper.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT ba.,ba.id as ba_id,bv.,bv.id as bv_id FROM pms_base_attr_info ba, pms_base_attr_value bv WHERE ba.id = bv.attr_id and bv.id in

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 9

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 9, dubbo version: 2.6.0, current host: 127.0.0.1