Typically implement this as using cron - you have some logic around which users should be sent a message, tracking this in the db, then send the notification when the cron job runs every day or week or whatever.