用外连接就行了啊
SELECT t1.uuid, t1.id, t1.username, t2.type, t2. status from t1 left join t2 on t1.uuid = t2.t1_uuid and t1.type <> t2.type
你是oracle，还是mysql啊
