insert into fin_subject_count (UID,subject_id,subject_count_type,balance,object_id,state,gmt_create,gmt_modified)
select
(SELECT count(*) as dd FROM bas_business_unit as a where a.unit_uid<b.unit_uid)+1000 as newUid
,
(SELECT count(*) as dd FROM bas_business_unit as a where a.unit_uid<b.unit_uid)+1000 as subject_id
,1,0,b.unit_uid,1,now(),now() from bas_business_unit as b