UPDATE salary_rule AS sr JOIN salary_template AS st ON sr.template_id = st.id SET sr.rule_ratio = JSON_ARRAY(JSON_OBJECT('payDate', st.pay_date, 'ratio', 1)) WHERE st.bu_id = 99 and sr.select_state = 1;
UPDATE salary_rule AS sr JOIN salary_template AS st ON sr.template_id = st.id SET sr.rule_ratio = JSON_ARRAY(JSON_OBJECT('payDate', st.pay_date, 'ratio', 1)) WHERE st.bu_id = 99 and sr.select_state = 1;