select a.user_name,b.skill,c.skill
from user1 a
join user1_skills b on a.id = b.user_id and b.skill="念经"
join user1_skills c on b.user_id = c.user_id and c.skill="变化"
join user1_skills d on d.user_id = c.user_id and d.skill="腾云"
where b.skill_level > 0 and c.skill_level>0 and d.skill_level>0
