php - 从内部连接查询中获取数据

Question

你好请帮我解决这个问题，我正在从不同的表中获取数据我面临的问题是表中有类似的列名，如员工名和用户名。查询工作完美，但我正在谈论如何将这些数据显示为

$data["employee.name"]
$data["user.name"]

这里是查询:

SELECT task.employee_id , task.user_id , task.service_id, user.name, 
       user.pic_path , employee.name ,employee.pic_path 
FROM task  
INNER JOIN employee ON employee.pno = task.employee_id  
INNER JOIN user ON user.pno = task.user_id 
INNER JOIN service ON service.service_id = task.service_id ";

Answer 1

SELECT user.name AS username, employee.name AS employeename

你明白了。