ylrz_saas_his_scrm/sql/_crm_paths.py

# -*- coding: utf-8 -*-
import pymysql

M=dict(host='cq-cdb-8fjmemkb.sql.tencentcdb.com',port=27220,user='root',password='Ylrz_1q2w3e4r5t6y',database='ylrz_saas',charset='utf8mb4')
c=pymysql.connect(**M);cur=c.cursor()
cur.execute("""
SELECT menu_id, menu_name, parent_id, path, component, menu_type, visible
FROM tenant_sys_menu
WHERE parent_id=32347 OR menu_id=32347 OR parent_id=35020
ORDER BY parent_id, order_num, menu_id
""")
for r in cur.fetchall():
    print(r)
c.close()