SQL query where I get a single column as an array

Here is my data customer_id, user_id, value, year c1, u1, 100, 2022 c1, u2, 200, 2022 c1, u3, 300, 2022 I want to get values of all the users of customer c1 in an array after a sql query. How do I ac