-- 更新主/子账号
UPDATE `zm_account` p,
(
SELECT * FROM (
(
  SELECT sub_id, ma_id
  FROM `zm_ma_subaccount`
  WHERE ma_id IN
    (SELECT c.account_id
     FROM `zm_account` c, `zm_user` u
     WHERE c.owner_id = u.user_id
     AND u.email IN ('yxt_qida@hotmail.com','yunxuetanghh@gmail.com','yunxuetangrt@gmail.com','yxt_liantong@hotmail.com'))
 ) ) AS t) tt

SET p.feature_options = (p.feature_options | 0x1)
WHERE p.account_id = tt.sub_id OR p.account_id = tt.ma_id