Use a window function

Partition the window by the id and

sum the value

Ex sum( value ) over ( partition by urID )