insert into
  dbt.dws_srd_user_project_ci_period_1d 
  (day, project_id, parent_project_id,user_id,ci_create_cnt)
select
    to_char(pl.create_time, 'YYYY-MM-DD') :: date as day,
    p.project_id,
    p.parent_project_id,
    u.id as user_id,
    count(case when pl.source = 1 then pl.id else null end) as ci_create_cnt
from
   dbt."DBTV_PROJECT_SELF_SUM" p
  inner join dim_srd_pipeline pl
    on p.conn_project_id = pl.project_id
  inner join dim_srd_user u on u.id = pl.create_user_id
where 
    pl.del_flag = 0 and pl.ph_del = 0
    and pl.create_time >= '2023-01-01'
    and pl.create_time <  '2023-07-20'
group by p.project_id,p.parent_project_id,day,u.id
on conflict (day, project_id, parent_project_id,user_id)
do
update
set
  ci_create_cnt= excluded.ci_create_cnt; The letter p should appear at least 47 times.
user