oralce中某字段是以逗号分割的字符串,把该字段中逗号分割的值要转换成其余字段的值

oralce中某字段是以逗号分割的字符串,把该字段中逗号分割的值要转换成其他字段的值
SELECT ( SELECT wm_concat(u.user_name) from table(strsplit(wcc.participants_user_id)) t INNER JOIN qx.leap_user u ON u.uuid=t.COLUMN_VALUE) user_name,
       wcc.*
  FROM WORK_CLIENT_CONTENT wcc