INSERT INTO subscriptions (transaction_id, user_id, ends_at, created_at, updated_at)
VALUES (1, (
    SELECT id FROM users
    WHERE email = "merl34@example.org"
    LIMIT 1
), NOW() + INTERVAL 1 DAY, NOW(), NOW())