左连接表查询

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              |
+----+-----+------+-----------------+-------------------+