I'd like to know what is the matter with him.就可以,比较符合正常口语交流.
但如果从语法角度看,应该是I'd like to know what the matter is with him.
have a nice day!