mysql 多表查询

Question

Answer 1

select u.id userId, u.name userName, r.name roleName, d.name departmentName from table user u left join table role r on u.id = r.user_id 
left join table department d on u.id = d.user_id 
where u.is_deleted = false