Save as user_delete.php, run once in browser. Set cron to run this once a year

Code:
include ('include/config.php');

$sql = mysql_query("DELETE FROM signup WHERE account_status='inactive'") or die(mysql_error());