SELECT
  *
FROM (SELECT
  TOP 10
    r.cutomer_id
   ,c.[Week]
   ,r.id
  FROM r
  JOIN c
    ON r.Create_date = c.Date
  WHERE Is_ride = 1
  AND ((Create_date_int BETWEEN 20190302 AND 20190319)
  OR (Create_date_int BETWEEN 20190406 AND 20190426))) p
PIVOT
(
COUNT(id)
FOR [Week] IN
([9], [10], [11], [12], [14], [15], [16], [17])
) AS pvt

DROP TABLE IF EXISTS #t
CREATE TABLE #t (
  customer_id INT
 ,WEEK INT
 ,id INT
)

INSERT #t (customer_id, WEEK, id)
  VALUES (12032, 10, 8607)
  , (43551, 10, 8721051)
  , (55025, 10, 81200)
  , (198874, 10, 861362)
  , (99675, 10, 867081)
  , (19387, 10, 863656)
  , (12526, 10, 8603706)
  , (19503, 10, 860924)
  , (37597, 10, 860909)
  , (136019, 10, 8610674);

SELECT
TOP 10
  r.cutomer_id
 ,c.[Week]
 ,r.id INTO #t
FROM r
JOIN c
  ON r.Create_date = c.Date
WHERE Is_ride = 1
AND ((Create_date_int BETWEEN 20190302 AND 20190319)
OR (Create_date_int BETWEEN 20190406 AND 20190426))

SELECT
  *
FROM #t
PIVOT
(
COUNT(id)
FOR [Week] IN
([9], [10], [11], [12], [14], [15], [16], [17])
) AS pvt

WHERE Is_ride = 1
    AND ((Create_date_int BETWEEN 20190302 AND 20190319)
    OR (Create_date_int BETWEEN 20190406 AND 20190426))
    and passenger_id in (43551,12032,136019)
            ) p