t_client表：+----+-----+------------------------+--------------+| id | pid | name | client_level |+----+-----+------------------------+--------------+| 1 | 0 | 所有分销商 | NULL || 2 | 1 | 华北区 | NULL || 3 | 2 | 北京 | NULL || 4 | 3 | 北京市医药股份有限公司 | A03 || 5 | 1 | 东北区 | NULL || 6 | 5 | 吉林省 | NULL || 7 | 5 | 辽宁省 | NULL || 8 | 5 | 黑龙江省 | NULL |+----+-----+------------------------+--------------+
t_data_dict表：+-----+------------+-------------------+| id | name | category |+-----+------------+-------------------+| A01 | 一级分销商 | client_level || A02 | 二级分销商 | client_level || A03 | 三级分销商 | client_level || A04 | 总部 | client_level |+-----+------------+-------------------+
根据id查询分销商：select a.id, a.pid, a.name, a.client_level as client_level_id, b.name as client_level_name from t_client a left join t_data_dict b on a.client_level = b.id where a.id = 3;
结果：+----+-----+------+-----------------+-------------------+| id | pid | name | client_level_id | client_level_name |+----+-----+------+-----------------+-------------------+| 3 | 2 | 北京 | NULL | NULL |+----+-----+------+-----------------+-------------------+
相关资源：敏捷开发V1.0.pptx
