第一种情况,三个表关联字段分开
select * from t_organization AS o
left join t_department AS d ON o.organization_id = d.organization_id
left join t_user AS u ON d.department_id = u.department_id;
第二种情况,三个表关联字段在主表
SELECT a.id, a.b_id, a.c_id, a.d_id, b.t_name, c.c_name, d.d_name FROM databasea a
LEFT JOIN databaseb b ON a.b_id = b.id
LEFT JOIN databasec c ON a.c_id = c.id
LEFT JOIN databasec d ON a.d.id = d.id