oracle将逗号隔开数据转换为行结构

select * from (
select usertypecrop from (SELECT regexp_substr(usertypecrop, '[^,]+', 1, rownum) usertypecrop,rownum FROM (SELECT usertypecrop FROM mini_user lecm WHERE usertype is not null ) CONNECT BY rownum <=(SELECT regexp_count(usertypecrop, ',')+1 FROM dual)) group by usertypecrop order by count(usertypecrop) desc
) w
left join (SELECT usertypecrop FROM mini_user) s on w.usertypecrop like s.usertypecrop