这可能有效
SELECT * FROM users u WHERE EXISTS ( SELECT * FROM MainPage WHERE CONCAT(',',doctors,',') LIKE CONCAT('%,',u.uid,',%') AND Valid = 1 )