如何仅从行加入特定字段

Question

I am wondering if there is a way to join only those rows, that have have columns slider set to 0 in my query. Right now it looks like

    $db->queryCache('SELECT ' . $objectFields . ' FROM people o
LEFT JOIN zdjecia z ON z.obiekt=o.id
LEFT JOIN obkat ON obkat.obiekt=o.id
WHERE o.ac=1
GROUP BY o.id
ORDER BY priorytet DESC', array(
    'people',
    'obkat',
    'zdjecia'
), 3600);

I wish to join only those rows from zdjecia that have column canUse set to 1

I tried:

    $db->queryCache('SELECT ' . $objectFields . ' FROM people o
LEFT JOIN zdjecia z ON z.obiekt=o.id
LEFT JOIN obkat ON obkat.obiekt=o.id
WHERE o.ac=1 AND z.canUse=1
GROUP BY o.id
ORDER BY priorytet DESC', array(
    'people',
    'obkat',
    'zdjecia'
), 3600);

but that did not help. What is a proper way to join only certain rows from table in query like this one?

Thanks!