select m, array_agg(p) as ps from ... where u = N group by m;
[download]

Assuming a quite recent version of postgresql (or even an old version of postgresql where you implement your own version of array_agg(), which is pretty easy to do).