Set the end date for all active members on a membership level.

query.sql

/*
SQL query to update the membership end date for all active members on the membership level with ID X.
This example sets it to midnight of August 31 2021.

Please replace X with the correct membership level ID.

As always, backup your database before running raq queries of this form.
*/

UPDATE wp_pmpro_memberships_users SET enddate = '2021-08-31 23:59:59' WHERE status = 'active' AND membership_id = X;