The PMD rule Avoid SOQL queries inside loops should have the highest priority when running...

Set the rule violation score in the PMD Default RuleSet to 1.

Change the rule priority in the PMD Default RuleSet to 1. (I think this is correct as priority start from 1 still we need to check in PMD doc)

Change the rule priority in the PMD Default RuleSet to 0.

Create a new rule and set the priority to Blocker. Then, add it to the Default RuleSet.