我不考虑id，id应该是行的唯一标识符，它除了用于唯一标识行之外没有任何意义。

create or replace view myview as 
 select project_user_id, name,
 row_number() over (partition by project_user_id order by null) as id
 from mytable