shopkeeperchange 店长变更表 - sid ：主键 - staffid ：员工id - branchid ：分店id - deptid ：部门id - roleid ：角色id - newbranchid ：新的分店id - newdeptid ：新的部门id - newroleid ：新的角色id

SELECT sc.id, sc.staffid, s.staffname, sc.branchid, b1.branchname, sc.deptid, d1.deptname, sc.newbranchid, b2.branchname, sc.newdeptid, d2.deptname, sc.newroleid, r.rolename, sc.transferper, sp.staffname FROM shopkeeperchange sc INNER JOIN staff s ON sc.staffid = s.id INNER JOIN branch b1 ON sc.branchid = b1.id INNER JOIN department d1 ON sc.deptid = d1.deptid INNER JOIN branch b2 ON sc.newbranchid = b2.id INNER JOIN department d2 ON sc.newdeptid = d2.deptid INNER JOIN role r ON sc.newroleid = r.roleid INNER JOIN staff sp ON sc.transferper = sp.id;