关于左连接的mysql数据查询问题?

wjz

SELECT b.id,(SELECT SUM(class)FROM a JOIN b ON a.id =b.id WHERE b.id=1),(SELECT COUNT(class) FROM a JOIN b ON a.id=b.id WHERE b.id=1),class
FROM b
WHERE b.uid =4