select p.idArts p.nicknickname camera p.createspottime, from
(select sys_user.id,sys_user.nick_name,sys_user.create_time
from sys_user
inner join sys_user_role on sys_user.id=sys_user_role.user_id
inner join sys_role on sys_role.id=sys_user_role.role_id and sys_role.role_name=" partner") p
the above statement queries the basic information, and needs to query the data of the id whose field is business_id p from the door-to-door basic information p according to its id, to the player table. How to write SQL.