insert into jinhong.ims_xiaofeiren_fenxiao_member

(id, weid,openid,nickname,follow,username,weixinhao,mobile,parent_id,isagent,commission_pay,agenttime)

SELECT id,weid,from_user,realname,1,banktype,wxhao,mobile,shareid,flag,zhifu,flagtime

FROM bensezhi.ims_bj_qmxk_member

 

 ims_xiaofeiren_fenxiao_member m,

ims_bj_qmxk_order o  m.jifen  (  ( price ) 

FROM ims_bj_qmxk_order

WHERE STATUS 1

 from_user  m.openid ) 

WHERE m.openid  o.from_user