import pandas as pd
import pymssql
sql='SELECT DISTINCT a.goods_name,a.brand_id,name FROM goods a LEFT JOIN goods_brand b ON a.brand_id=b.id'
conn=pymssql.connect(host='localhost,user='XX',password='XX',database='db')
df=pd.read_sql(sql,conn)
df.to_csv('test.csv',index=False)