You could use the String_split table function:

SELECT TRIM(value) AS pid
FROM STRING_SPLIT('U388279963, U388631403, U389925814', ... ',')