Use the below SOQL to fetch Marketing User field from User object Salesforce.

SOQL:

SELECT Id, UserPermissionsMarketingUser FROM User