Group by ID ,Group by ID ,Group by ID ,Group by ID ,Group by ID ,Group by ID , : Im new in coding so please if u a have answer , just say it in easy way !

i have many users with unique userID in table-1 with their specifications,
i have other table-2 that Supervisors choose  hours that users work
.(i connect userID of table-2 to table-1 and it's ok)
supervisors are many so maybe their is many row with different hour for same useriD.
so i create view  with

     select w_userid,sum(w_hour)as total from Workk group by w_userid 

for show me one userID with sum of his hours.



 

but i cant add it in database layer .so could someone help me ?