Fix `pkg check -d` and `pkg query %d` not returning missing deps

This needs to be a LEFT JOIN instead of INNER JOIN since the
package entry may be missing. It's still a valid dependency
though and should show up under PKG_LOAD_DEPS

Broken by 7021b09df