MariaDB 10.2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE members
(
    memberid integer PRIMARY KEY,
    name varchar(100)
) ;
INSERT INTO members
    (memberid, name)
VALUES
    (1, 'member 1'),
    (2, 'member 2') ;
CREATE TABLE fees
(
    memberid integer REFERENCES members(memberid),
    amountpaid decimal(10,2) NOT NULL,
    paiddate date NOT NULL
) ;
INSERT INTO fees
   (memberid, amountpaid, paiddate)
VALUES
   (1, 100.0, curdate()),
   (2, 100.0, curdate() - interval 1 month);
SELECT * FROM fees JOIN members ON fees.memberid = members.memberid;


memberid
amountpaid
paiddate
memberid
name


1
100.00
2019-06-17
1
member 1

2
100.00
2019-05-17
2
member 2


SELECT
    memberid, name  /* , and anything you need */
FROM
    members
    /* JOIN fees ON fees.memberid = members.memberid */
WHERE
    NOT EXISTS
    (
    /* any payment from this specific member this month */ 
    SELECT 
        1
    FROM
        fees
    WHERE
        fees.memberid = members.memberid   AND
        YEAR(paiddate)  = YEAR(curdate())  AND
        MONTH(paiddate) = MONTH(curdate())
    ) ;


memberid
name


2
member 2