i have simple table
id | order_id | user_id |
---|---|---|
1 | 34 | 2 |
2 | 42 | 2 |
3 | 45 | 3 |
4 | 46 | 3 |
5 | 47 | 2 |
i want to group order_ids by user_id order. so i will have result like this
- 34,42
- 45,46
- 47
so make group order_ids while user_ids are same. then start grouping again