Mysql巧用join优化sql的方法详解:0. 准备相关表来进行接下来的测试 相关建表语句请看：https://github.com/YangBaohust/my_sql user1表，取经组 +----+-----------+-----------------+---------------------------------+ | id | user_name