一、取消where条件
SELECT
T.xx,
T1.xx,
...
FROM xxx T
LEFT JOIN xxx T1
ON T.ID = T1.ID AND T.xx = xx AND T1.xx = xx
二、使用group by
参考:
https://blog.csdn.net/qq814965130/article/details/79001031
https://www.icode9.com/content-2-598071.html