want to fetch the records that contains at least one value from the array in ID column.

want to fetch the records that contains at least one value from the array in ID column.
while the array contains the keys of the JSON document stored in same table and the column name as Following set as JSON datatype

SELECT * FROM user WHERE CAST(ID AS CHAR) IN (SELECT JSON_KEYS(Following) FROM user WHERE ID = 1);