$query = $db->prepare("
SELECT SS.SERIESNO FROM STOCKSERIESTRANS SSR
    JOIN STOCKSERIES SS ON SS.STOCKSERIESID = SSR.STOCKSERIESID
WHERE SSR.ROOTID IN(
    SELECT WP.RECEIPTID FROM WORKPRO WP WHERE WP.ACTID = :ACTID AND WP.ORDERRECEIPTID = :ORDERRECEIPTID
)
");

$query->execute([
    'ACTID' => $cariyigetir['ACTID'],
    'ORDERRECEIPTID' => $siparisigetir['RECEIPTID'],
]);

print_r($query->fetchAll(PDO::FETCH_COLUMN));