sql优化

1、插入一张表的数据到另一张表：

    insert into mt_wx_role(uuid,role_name,user_uuid) select UUID(),'deputy',uuid from mt_wx_user

2、分组查询：

    SELECT t12.v_count AS COUNT, t11.UUID,t11.seqname,t11.dirname,t11.dirtel,t11.lianame,t11.liatel FROM mt_wx_seq t11 LEFT JOIN (SELECT seqID,COUNT(*) AS v_count FROM mt_wx_user GROUP BY seqID ) t12 ON t12.seqID = t11.UUID