SELECT job.nameSId,job.profileId,pr.userId From user_user_profile_job job
LEFT join user_user_profile pr on
pr.id=job.profileId and pr.userId=5340
LEFT join user_user_profile pr on
pr.id=job.profileId and pr.userId=5340
LEFT join user_user_profile pr on
pr.profileId=job.profileId and pr.userId=5340